Postgres respond after toomany times to a query view

Поиск
Список
Период
Сортировка
От Claudia D'amato
Тема Postgres respond after toomany times to a query view
Дата
Msg-id 7965BF282720D8118ED70050BA4E75760A955A@ml370.omarnet.it
обсуждение исходный текст
Список pgsql-hackers
<p><font face="Arial" size="2">Hi, I developing a program using postgres and linux like operating system. My problem is
this:</font><br/><font face="Arial" size="2">I have a quite complicated view with roughly 10000 record. When I execute
asimple query like this </font><br />        <font face="Arial" size="2">"select * from myview"</font><br /><font
face="Arial"size="2">postgres respond after 50 - 55 minutes roughly. I hope that someone can help me with some
suggestionabout reason of this behavior and some solution to reduce time ti have results. Thank you for your attentions
andI hope to receive some feedback as soon as possible</font> 

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

Предыдущее
От: Andreas Pflug
Дата:
Сообщение: Re: cascading column drop to index predicates
Следующее
От: shaikat
Дата:
Сообщение: Suggestions welcome for PhD topic in Distributed Database Systems (Planning to contribute to postgresql)