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
