Thanks..I'll try this. Should I also rebuild the contrib modules..or just the core postgres database? On Sat, Jun 5, 2010 at 2:38 AM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > On Fri, Jun 4, 2010 at 12:21 PM, Anj Adu <fotographs@xxxxxxxxx> 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. > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
