Some of the things u can do is.
VACCUM and ANALYZE tables; Create index on coulmn specified in where clause of the query.
Manoj
claudia wrote:
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
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
