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

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: Ryszard Lach <ryszard(at)lach(dot)name>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: 7.3 vs 7.2 - different query plan, bad performance
Date: 2003-06-15 19:48:08
Message-ID: ugipevc89eaqk90s23n8kd2iut5uvskpk4@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, 13 Jun 2003 20:45:06 +0200, Ryszard Lach <siaco(at)autograf(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tomaz Borstnar 2003-06-15 22:37:30 Re: any way to use indexscan to get last X values
Previous Message Tom Lane 2003-06-15 16:53:10 Re: any way to use indexscan to get last X values with "order by Y limit X" clause?