Re: work_mem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Subject: Re: work_mem
From: SASIKUMAR Devaraj <sashikumard@xxxxxxxxx>
Date: Sat, 3 Apr 2021 06:15:37 +0000 (UTC)
Cc: "Campbell, Lance" <lance@xxxxxxxxxxxx>, Bruce Momjian <bruce@xxxxxxxxxx>, Laurenz Albe <laurenz.albe@xxxxxxxxxxx>, MichaelDBA <michaeldba@xxxxxxxxxxx>, "holger@xxxxxxxxxx" <holger@xxxxxxxxxx>, "pgsql-admin@xxxxxxxxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
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@xxxxxxxxx> wrote:

On Friday, April 2, 2021, SASIKUMAR Devaraj <sashikumard@xxxxxxxxx> 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.

References:
- work_mem
  - From: Campbell, Lance
- Re: work_mem
  - From: Holger Jakobs
- Re: work_mem
  - From: SASIKUMAR Devaraj
- Re: work_mem
  - From: MichaelDBA
- Re: work_mem
  - From: SASIKUMAR Devaraj
- Re: work_mem
  - From: MichaelDBA
- Re: work_mem
  - From: Campbell, Lance
- Re: work_mem
  - From: Laurenz Albe
- Re: work_mem
  - From: Bruce Momjian
- Re: work_mem
  - From: Campbell, Lance
- Re: work_mem
  - From: Bruce Momjian
- Re: work_mem
  - From: SASIKUMAR Devaraj
- Re: work_mem
  - From: David G. Johnston

Prev by Date: Re: work_mem
Next by Date: Re: Thank you!
Previous by thread: Re: work_mem
Next by thread: Global memory or local memory? (was Re: work_mem)
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]