Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group