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

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?

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