Re: Slow query - Mailing list pgsql-general

From Yonatan Goraly
Subject Re: Slow query
Date
Msg-id 3F9CD067.7030301@sbcglobal.net
Whole thread Raw
In response to Re: Slow query  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
yes

Alvaro Herrera wrote:

>On Mon, Oct 27, 2003 at 12:08:31AM +0200, Yonatan Goraly wrote:
>
>
>>I have a query that uses the same view 6 times. It seems that the
>>database engine is calculating the view each time.
>>The result is very poor performance. The same query takes 2 sec with MS
>>SQL, and more than 10 sec with PostgreSQL.
>>Is there a method to improve the performance besides merging the
>>components of the view into one table?
>>
>>
>
>Say, have you ANALYZEd your tables ?
>
>
>


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Slow query
Next
From: "Patrick Hatcher"
Date:
Subject: Re: PostgreSQL with MS Query?