On 16 Dec 2003, 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
We'll need to see a couple things: schema of the underlying tables, your view definition, and the output of: "explain analyze select * from view;" Also, what version of postgresql are you running? ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings