Hello > > The 8.4 machines have more memory than the 8.3.7 and are in general much > better machines. > 8.4 settings > Shared_buffers 18GB > effective_cache_size 18GB > > Machines have 72GB of RAM > Tried turning off sequential scan on the 8.4.5 and that did not help. > > Any ideas/suggestions? >
increase statistics on columns. The estimation is totally out. Regards Pavel Stehule > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
