Postgres Pro
Downloads
Home   >   mailing lists

Re: work_mem - Mailing list pgsql-admin

From SASIKUMAR Devaraj
Subject Re: work_mem
Date
Msg-id 1083971116.2431044.1617430537771@mail.yahoo.com
Whole thread Raw
In response to Re: work_mem  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Tree view
Excellent. Thank you very much for the clarification. Much Appreciated.

Regards

Sasi

On Saturday, 3 April, 2021, 11:14:36 am IST, David G. Johnston <david.g.johnston@gmail.com> wrote:



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: "David G. Johnston"
Date:
Subject: Re: work_mem
Next
From: Katherine Mcmillan
Date:
Subject: Re: Thank you!