On Wed, Oct 21, 2015 at 2:45 PM, Pavel Stehule <[email protected]> wrote: > 2015-10-21 21:32 GMT+02:00 Jamie Koceniak <[email protected]>: >> >> 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 -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
