On Wed, Jun 9, 2010 at 11:17 PM, Anj Adu <fotographs@xxxxxxxxx> wrote: > The plan is unaltered . There is a separate index on theDate as well > as one on node_id > > I have not specifically disabled sequential scans. Please do "SHOW ALL" and attach the results as a text file. > This query performs much better on 8.1.9 on a similar sized > table.(althought the random_page_cost=4 on 8.1.9 and 2 on 8.4.0 ) Well that could certainly matter... -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
