| From: | Rod Taylor <pg(at)rbt(dot)ca> |
|---|---|
| To: | "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com> |
| Cc: | Postgresql Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Odd sorting behaviour |
| Date: | 2004-07-21 14:58:12 |
| Message-ID: | 1090421892.21450.7.camel@jester |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stefan | 2004-07-21 16:25:55 | Re: extrem bad performance |
| Previous Message | Steinar H. Gunderson | 2004-07-21 10:04:10 | Re: Odd sorting behaviour |