Postgres Pro
Downloads
Home   >   mailing lists

Re: 7.3 vs 7.2 - different query plan, bad performance - Mailing list pgsql-performance

From Manfred Koizar
Subject Re: 7.3 vs 7.2 - different query plan, bad performance
Date
Msg-id ugipevc89eaqk90s23n8kd2iut5uvskpk4@4ax.com
Whole thread Raw
In response to 7.3 vs 7.2 - different query plan, bad performance  (Ryszard Lach <siaco@autograf.pl>)
Responses Re: 7.3 vs 7.2 - different query plan, bad performance  (siaco@allegro.pl)
List pgsql-performance
Tree view 
On Fri, 13 Jun 2003 20:45:06 +0200, Ryszard Lach <siaco@autograf.pl>
wrote:
>I have a problem with performance after upgrading from 7.2 to 7.3.

Try
    VACUUM ANALYSE;

and then re-run your query.  If it is still slow, post the new EXPLAIN
ANALYSE output here.

Servus
 Manfred

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: any way to use indexscan to get last X values with "order by Y limit X" clause?
Next
From: Tomaz Borstnar
Date:
Subject: Re: any way to use indexscan to get last X values