postgres does not respond to a query view of 10000 records roughl y

Поиск
Список
Период
Сортировка
От Claudia D'amato
Тема postgres does not respond to a query view of 10000 records roughl y
Дата
Msg-id 7965BF282720D8118ED70050BA4E75760A9517@ml370.omarnet.it
обсуждение исходный текст
Ответы Re: postgres does not respond to a query view of 10000  (Jonathan Bartlett <johnnyb@eskimo.com>)
Список pgsql-general

Hi, I developing a program usinn postgres and linux like system operation. My problem is this:
I have a view quite complicated with roughly 10000 record. When I execute a simple query like this
        "select * from myview"
postgres does not respond and does not produce any results. I hope that someone can help me with some suggestion about reason of this behavior and some solution to avoid it. Thank you for your attentions and I hope to receive some feedback as soon as possible

В списке pgsql-general по дате отправления:

Предыдущее
От: "Jeff Cave"
Дата:
Сообщение: Re: Any commercial shopping cart packages using postgresql?
Следующее
От: Troels Arvin
Дата:
Сообщение: Re: LIMIT modifier