It would be good if u can give text of the view and table structure of
the two tables.
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
>
>
>
>