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?