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