Re: Weird performance drop after VACUUM - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: Weird performance drop after VACUUM
Date
Msg-id 20050827101945.GA18155@uio.no
Whole thread Raw
In response to Re: Weird performance drop after VACUUM  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Weird performance drop after VACUUM
List pgsql-performance
On Fri, Aug 26, 2005 at 07:31:51PM -0400, Tom Lane wrote:
> Or you could just play with the order of the filter conditions ... for
> example, the date condition at the end is probably far cheaper to test
> than the text comparisons, so if that's fairly selective it'd be worth
> putting it first.

That's an interesting approach -- could the planner do such things itself?

/* Steinar */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: Umit Oztosun
Date:
Subject: Re: Weird performance drop after VACUUM
Next
From: Arjen van der Meijden
Date:
Subject: Re: Inefficient queryplan for query with intersectable