Re: Global memory or local memory? (was Re: work_mem) - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Global memory or local memory? (was Re: work_mem)
Date
Msg-id CAKFQuwaTMFYG0sw7eg9ToUhDov=jeH36nCgtVK96p8XyD14OcA@mail.gmail.com
Whole thread Raw
In response to Global memory or local memory? (was Re: work_mem)  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-admin
On Friday, April 2, 2021, Ron <ronljohnsonjr@gmail.com> wrote:

If multiple users are querying the same regions of the same tables, does each process have to read the same blocks, or can they share ("oh look, some other process has already read into memory some of the data blocks I need, so I'll just share those buffers")?


All data pages are manipulated while in the shared memory area.  The size of which is controlled by the “shared_buffers” configuration option.

David J.
 

pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Global memory or local memory? (was Re: work_mem)
Next
From: SASIKUMAR Devaraj
Date:
Subject: Re: work_mem