Postgres Pro
Downloads
Home   >   mailing lists

Re: work_mem - Mailing list pgsql-admin

From David G. Johnston
Subject Re: work_mem
Date
Msg-id CAKFQuwY3vS9eegPQqu+c5JD1CZw1x2wSxTkG8bTHPVU=PxCmAA@mail.gmail.com
Whole thread Raw
In response to Re: work_mem  (SASIKUMAR Devaraj <sashikumard@yahoo.com>)
Responses Re: work_mem  (SASIKUMAR Devaraj <sashikumard@yahoo.com>)
List pgsql-admin
Tree view

On Friday, April 2, 2021, SASIKUMAR Devaraj <sashikumard@yahoo.com> wrote:

Case 1: 
work_mem=4m
Total Sessions connected=100
Total=400M 

Or Case 2
work_mem=4m
Total Sort operations at DB now=50
Total work_mem=200M

Please clarify at high level whether Case 1 is true or Case 2 is true?

Case 2

David J.

pgsql-admin by date:

Previous
From: SASIKUMAR Devaraj
Date:
Subject: Re: work_mem
Next
From: SASIKUMAR Devaraj
Date:
Subject: Re: work_mem