On Wed, Oct 21, 2015 at 2:45 PM, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote: > 2015-10-21 21:32 GMT+02:00 Jamie Koceniak <jkoceniak@xxxxxxxxxxxxx>: >> >> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
