Обсуждение: Postgres respond after toomany times to a query view
<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>
It would help us to help you if you posted the view, tables involved and indexes on those table. Also things like some of the postgresql.conf parameters would help. Things like "effective_cache_size", "sort_mem". Also how often the tables in the views are update and how often you vacuum analyze will have a big impact on performance.
----- Original Message -----From: Claudia D'amatoSent: Tuesday, December 16, 2003 3:15 AMSubject: [HACKERS] Postgres respond after toomany times to a query viewHi, I developing a program using postgres and linux like operating system. My problem is this:
I have a quite complicated view with roughly 10000 record. When I execute a simple query like this
"select * from myview"
postgres respond after 50 - 55 minutes roughly. I hope that someone can help me with some suggestion about reason of this behavior and some solution to reduce time ti have results. Thank you for your attentions and I hope to receive some feedback as soon as possible