pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: SASIKUMAR Devaraj <sashikumard@yahoo.com>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: Campbell, Lance <lance@illinois.edu>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: MichaelDBA <michaeldba@sqlexec.com>
Cc: holger@jakobs.com <holger@jakobs.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: work_mem
Date: Sat, 3 Apr 2021 06:15:37 +0000 (UTC)
Message-ID: <1083971116.2431044.1617430537771@mail.yahoo.com> (raw)
In-Reply-To: <CAKFQuwY3vS9eegPQqu+c5JD1CZw1x2wSxTkG8bTHPVU=PxCmAA@mail.gmail.com>
References: <A2AA6D08-9506-4B41-9738-4D5FF8E2E011@illinois.edu>
	<04D84259-1B75-4648-949F-78677916194E@jakobs.com>
	<66290583.2329958.1617367063840@mail.yahoo.com>
	<c1e02a03-71cd-4071-e000-967403bcab9d@sqlexec.com>
	<1654783699.2333997.1617367552583@mail.yahoo.com>
	<592e5895-8dbd-1a4f-a87c-af72ac8eea02@sqlexec.com>
	<SN6PR11MB3326EADE632BA4EBE1FA28DCDE7A9@SN6PR11MB3326.namprd11.prod.outlook.com>
	<339e1ee870881a3efaffc7ea4cddac6bc4d009cf.camel@cybertec.at>
	<20210402150736.GD9270@momjian.us>
	<SN6PR11MB332665A6DF1226BF762A44B9DE7A9@SN6PR11MB3326.namprd11.prod.outlook.com>
	<20210402153436.GE9270@momjian.us>
	<230367927.2421710.1617427436762@mail.yahoo.com>
	<CAKFQuwY3vS9eegPQqu+c5JD1CZw1x2wSxTkG8bTHPVU=PxCmAA@mail.gmail.com>

 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=4mTotal Sessions connected=100Total=400M 
Or Case 2work_mem=4mTotal Sort operations at DB now=50Total work_mem=200M
Please clarify at high level whether Case 1 is true or Case 2 is true?

Case 2
David J.  

view thread (22+ messages)  latest in thread

Message-ID: <1083971116.2431044.1617430537771@mail.yahoo.com>
Permalink:  ../1083971116.2431044.1617430537771@mail.yahoo.com/
Also on:    postgresql.org/message-id/1083971116.2431044.1617430537771@mail.yahoo.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: sashikumard@yahoo.com, david.g.johnston@gmail.com, lance@illinois.edu, bruce@momjian.us, laurenz.albe@cybertec.at, michaeldba@sqlexec.com, holger@jakobs.com, pgsql-admin@lists.postgresql.org
  Subject: Re: work_mem
  In-Reply-To: <1083971116.2431044.1617430537771@mail.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox