On Wed, Oct 21, 2015 at 2:45 PM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
> 2015-10-21 21:32 GMT+02:00 Jamie Koceniak <jkoceniak(at)mediamath(dot)com>:
>>
>> adama_prod=# SHOW shared_buffers;
>>
>> shared_buffers
>>
>> ----------------
>>
>> 64GB
>
>
> can you try to increase shared buffers to 200GB and decrease effective cache
> size to 180GB? If it is possibly - I am not sure, if this setting is good
> fro production usage, but the result can be interesting for bottleneck
> identification.
we need to see a snapshot from
*) top
*) perf top
merlin