Re: work_mem RAM Accounting in PostgreSQL

2024-11-18 Thread Laurenz Albe
On Mon, 2024-11-18 at 18:11 +0200, Alexandru Lazarev wrote: > Highly appreciate your response. But I have some additional questions (inline) > > On Thu, Nov 14, 2024 at 4:40 PM Laurenz Albe wrote: > > On Wed, 2024-11-13 at 21:09 +0200, Alexandru Lazarev wrote: > > > > > My questions are as follo

Re: work_mem RAM Accounting in PostgreSQL

2024-11-18 Thread Alexandru Lazarev
Hi @Laurenz Albe & PG Community, Highly appreciate your response. But I have some additional questions (inline) On Thu, Nov 14, 2024 at 4:40 PM Laurenz Albe wrote: > On Wed, 2024-11-13 at 21:09 +0200, Alexandru Lazarev wrote: > > I have some questions regarding how the "work_mem" parameter affe

Re: work_mem RAM Accounting in PostgreSQL

2024-11-14 Thread Laurenz Albe
On Wed, 2024-11-13 at 21:09 +0200, Alexandru Lazarev wrote: > I have some questions regarding how the "work_mem" parameter affects the > overall RAM > usage of PostgreSQL processes within a physical host or container. > > Each backend process during SQL execution may allocate N * "work_mem" > si

work_mem RAM Accounting in PostgreSQL

2024-11-13 Thread Alexandru Lazarev
Hello Everyone, I have some questions regarding how the "work_mem" parameter affects the overall RAM usage of PostgreSQL processes within a physical host or container. Each backend process during SQL execution may allocate N * "work_mem" simultaneously. For example, if "work_mem" is set to 32MB a