Re: Global memory or local memory? (was Re: work_mem)

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Global memory or local memory? (was Re: work_mem)
Date: 2021-04-02 22:58:06
Message-ID: CAKFQuwaTMFYG0sw7eg9ToUhDov=jeH36nCgtVK96p8XyD14OcA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Friday, April 2, 2021, Ron <ronljohnsonjr(at)gmail(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message SASIKUMAR Devaraj 2021-04-03 05:23:56 Re: work_mem
Previous Message Ron 2021-04-02 22:35:01 Global memory or local memory? (was Re: work_mem)