Re: Odd sorting behaviour - Mailing list pgsql-performance

From Rod Taylor
Subject Re: Odd sorting behaviour
Date
Msg-id 1090421892.21450.7.camel@jester
Whole thread Raw
In response to Re: Odd sorting behaviour  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
List pgsql-performance
On Wed, 2004-07-21 at 06:04, Steinar H. Gunderson wrote:
> On Tue, Jul 20, 2004 at 10:18:19PM -0400, Rod Taylor wrote:
> > I've taken a look and managed to cut out quite a bit of used time.
> > You'll need to confirm it's the same results though (I didn't -- it is
> > the same number of results (query below)
>
> It looks very much like the same results.

Oh.. On my (slow) laptop it cut the time back significantly..

> As my server is 7.2 and not 7.4, that obviously won't help much :-) Thanks
> anyway, though -- we'll upgrade eventually, and it'll help then.

I see. Yeah, avoid NOT IN like a plague on 7.2.



pgsql-performance by date:

Previous
From: "Steinar H. Gunderson"
Date:
Subject: Re: Odd sorting behaviour
Next
From: Stefan
Date:
Subject: Re: extrem bad performance