Postgres respond after toomany times to a query view
Hi, 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
Postgres respond after toomany times to a query viewIt 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'amato
To: pgsql-hackers@postgresql.org
Sent: Tuesday, December 16, 2003 3:15 AM
Subject: [HACKERS] Postgres respond after toomany times to a query view
Hi, 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