Re: Postgres respond after toomany times to a query view

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