On Wed, May 31, 2017 at 2:35 AM, Ashutosh Bapat <ashutosh.ba...@enterprisedb.com> wrote: > AFAIK, work_mem comes from memory private to the process whereas this > memory will come from the shared memory pool.
I don't think that really matters. The point of limits like work_mem is to avoid driving the machine into swap. Allocating shared memory might error out rather than causing swapping in some cases on some systems, but any difference between private and shared memory is not the real issue here. The issue is overall memory consumption. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers