| From: | Yonatan Goraly <ygoraly(at)sbcglobal(dot)net> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Slow query |
| Date: | 2003-10-27 07:59:35 |
| Message-ID: | 3F9CD067.7030301@sbcglobal.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 ?
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Klaus P. Pieper | 2003-10-27 08:21:07 | Experience with PL/xx? |
| Previous Message | Tom Lane | 2003-10-27 06:47:11 | Re: incrementing and decrementing dates by day increments |