Thread: Postgres respond after toomany times to a query view

Postgres respond after toomany times to a query view

From
Claudia D'amato
Date:
<p><font face="Arial" size="2">Hi, I </font><font color="#0000FF" face="Arial" size="2">am</font><font face="Arial"
size="2">  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 a simple query like this
</font><br/>        <font face="Arial" size="2">"select * from myview"</font><br /><font face="Arial" size="2">postgres
respondafter 50 - 55 minutes roughly. I hope that someone can help me with some suggestion about reason of this
behaviorand some solution to reduce time ti have results. Thank you for your attentions and I hope to receive some
feedbackas soon as possible</font>