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 -----
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