On Wed, Oct 10, 2012 at 1:10 PM, Bruce Momjian <bruce@momjian.us> wrote:
>> >shared_buffers = 10GB
>>
>> Generally going over 4GB for shared_buffers doesn't help.. some of
>> the overhead of bgwriter and checkpoints is more or less linear in
>> the size of shared_buffers ..
>>
>> >effective_cache_size = 90GB
>>
>> effective_cache_size should be ~75% of the RAM (if it's a dedicated server)
>
> Why guess? Use 'free' to tell you the kernel cache size:
>
> http://momjian.us/main/blogs/pgblog/2012.html#May_4_2012
Why does nobody every mention that concurrent access has to be taken
into account?
Ie: if I expect concurrent access to 10 really big indices, I'll set
effective_cache_size = free ram / 10
