Re: [PERFORM] New servers, need suggestions for sensible tuning settings

2010-08-25 Thread Kevin Grittner
Bob Branch wrote: > Is there a reference I can look at that will give me a description > of how to determine sensible values for settings like > shared_buffers, effective_cache_size, etc. that I see discussed on > this list and elsewhere? You might start with these links: http://wiki.postgre

[PERFORM] New servers, need suggestions for sensible tuning settings

2010-08-25 Thread Bob Branch
Hello! We've just installed a couple new servers that will be our new database servers. The basic hardware stats of each are: 2 x Xeon E5620 (2.4GHz quad-core) 32GB DDR3 1333 RAM 6 x 600GB 15krpm SAS drives - RAID 10 Perc 6/i RAID controller with battery backup I've lurked on this list for a