I suspect if you do "explain" against the SQL of the view, the answer
will be apparent.
 
Donning my "Karnak the magnificent hat {borrowed from Johnny Carson}":
You are missing an index.
 
For the best help, post the SQL of your view, and also the Schema
definition for the tables involved.

	-----Original Message-----
	From: Claudia D'amato [mailto:claudia.damato@allaxia.com] 
	Sent: Tuesday, December 16, 2003 2:32 AM
	To: pgsql-hackers@postgresql.org
	Subject: [HACKERS] 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


Message



I 
suspect if you do "explain" against the SQL of the view, the answer will be 
apparent.
 
Donning my "Karnak the magnificent hat {borrowed from Johnny Carson}": 
You are missing an index.
 
For 
the best help, post the SQL of your view, and also the Schema definition for the 
tables involved.


-----Original Message-----From: Claudia D'amato 
  [mailto:claudia.damato@allaxia.com] Sent: Tuesday, December 16, 
  2003 2:32 AMTo: pgsql-hackers@postgresql.orgSubject: 
  [HACKERS] 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 02:40:09 -0800
"Dann Corbit" <DCorbit@connx.com>
Re: Postgres respond after toomany times to a query view
Dann Corbit kirjutas T, 16.12.2003 kell 12:40:
> I suspect if you do "explain" against the SQL of the view, the answer
> will be apparent.
>  
> Donning my "Karnak the magnificent hat {borrowed from Johnny Carson}":
> You are missing an index.
>  
> For the best help, post the SQL of your view, and also the Schema
> definition for the tables involved.

Also, the best place for asking about performance is the
pgsql-performance list :)

------------
Hannu


Tue, 16 Dec 2003 13:01:30 +0200
Hannu Krosing <hannu@tm.ee>
Re: Postgres respond after toomany times to a query view