> 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.
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
In response to
pgsql-performance by date
|Next:||From: Divakar Singh||Date: 2010-10-27 14:00:15|
|Subject: Re: Postgres insert performance and storage requirement compared to Oracle|
|Previous:||From: Brad Nicholson||Date: 2010-10-27 12:42:33|
|Subject: Re: AIX slow buffer reads|