| Lists: | Postg토토 캔SQL : |
|---|
| From: | Claudia D'amato <claudia(dot)damato(at)allaxia(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Postgres respond after toomany times to a query view |
| Date: | 2003-12-16 10:32:14 |
| Message-ID: | 7965BF282720D8118ED70050BA4E75760A95AF@ml370.omarnet.it |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Hi, I am 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
| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | "Claudia D'amato" <claudia(dot)damato(at)allaxia(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Postgres respond after toomany times to a query view |
| Date: | 2003-12-16 11:01:37 |
| Message-ID: | 200312161101.37762.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | Postg토토 캔SQL : |
On Tuesday 16 December 2003 10:32, Claudia D'amato wrote:
> 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
Hi Claudio - you don't want the hackers list, you probably want the
performance list. You will want to do the following first:
1. VACUUM ANALYZE the tables used by the view.
2. Provide the output of EXPLAIN ANALYSE SELECT * FROM myview;
3. Provide the definitions of the tables used, and how many rows are in each
table.
I'll see you on the performance list, and we'll see if we can't help you this
afternoon.
--
Richard Huxton
Archonet Ltd