Does anyone have suggestions that could improve performance?
If you have doubled your ram you could definately increase your
effective_cache.
As you also doubled your memory you could increase your work_mem but be
careful with this setting.
Also just to be certain are you running 32bit
Hi,
We've been using a 4 CPU Opteron (16GB) for the past several months, and
have now upgraded to an 8 CPU machine with 32GB. Basically, we've taken
the postgresql.conf from the 4 way, and used that in the 8 way without
making any changes. Shared memory for postgresql in both machines is