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





Postgres respond after toomany times to a query view


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
Tue, 16 Dec 2003 11:32:14 +0100
Claudia D'amato <claudia.damato@allaxia.com>
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

Tue, 16 Dec 2003 11:01:37 +0000
Richard Huxton <dev@archonet.com>
Re: Postgres respond after toomany times to a query view