On Tue, Nov 5, 2013 at 8:37 AM, Евгений Селявка <evg.selyavka@xxxxxxxxx> wrote: > I set work_mem to 1/4 from available RAM. I have 32Gb RAM so i set > shared_buffers to 8Gb. I am sure you are mentioning shared_buffers here and not work_mem. work_mem is a per-operation parameter. So if you are using an operation involving work_mem more than 4 times simultaneously on different sessions you'll swap pretty quickly ;) -- Michael -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
