From: | manoj nahar <manoj(at)mail15(dot)com> |
---|---|
To: | claudia <claudia(dot)damato(at)allaxia(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postgres respond after toomany times to a query view |
Date: | 2003-12-17 19:10:45 |
Message-ID: | 3FE0AA35.8050009@mail15.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Murtagh | 2003-12-17 19:59:50 | Re: Permissions issue? |
Previous Message | Lynn.Tilby | 2003-12-17 18:58:44 | 7.1.3 ecpg |