Re: slow query - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: slow query
Date
Msg-id AANLkTimOIYuXbEylsRbF2rMjcz58pp3RgTdJCtSAJ-t4@mail.gmail.com
Whole thread Raw
In response to Re: slow query  (Anj Adu <fotographs@gmail.com>)
Responses Re: slow query  (Anj Adu <fotographs@gmail.com>)
List pgsql-performance
On Fri, Jun 4, 2010 at 12:21 PM, Anj Adu <fotographs@gmail.com> wrote:
> The behaviour is different in postgres 8.1.9 (much faster)  (the table
> has 9 million rows instead of 25 million..but the query comes back
> very fast (8 seconds)..
>
> Wonder if this is very specific to 8.4.0

You should really be running 8.4.4.

pgsql-performance by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: slow query
Next
From: Anj Adu
Date:
Subject: Re: slow query