Increased shared_buffer setting = lower hit ratio ?

From: CS DBA <cs_dba(at)consistentstate(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Increased shared_buffer setting = lower hit ratio ?
Date: 2014-11-13 23:09:18
Message-ID: 54653A1E.3050805@consistentstate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

All;

We have a large db server with 128GB of ram running complex functions.

with the server set to have the following we were seeing a somewhat low
hit ratio and lots of temp buffers

shared_buffers = 18GB
work_mem = 75MB
effective_cache_size = 105GB
checkpoint_segments = 128

when we increased the values to these not only did the hit ratio drop
but query times are now longer as well:

shared_buffers = 28GB
work_mem = 150MB
effective_cache_size = 105GB
checkpoint_segments = 256

This does not seem to make sense to me, anyone have any thoughts on why
more memory resources would cause worse performance?

Thanks in advance

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message CS DBA 2014-11-13 23:16:11 Re: Increased shared_buffer setting = lower hit ratio ?
Previous Message Filip Rembiałkowski 2014-11-13 08:10:23 9.0 performance degradation with kernel 3.11