From: SASIKUMAR Devaraj <sashikumard@yahoo.com>
To: holger@jakobs.com, Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: work_mem
Date: Fri, 2 Apr 2021 12:37:43 +0000 (UTC)
Message-ID: <66290583.2329958.1617367063840@mail.yahoo.com> (raw)
In-Reply-To: <04D84259-1B75-4648-949F-78677916194E@jakobs.com>
References: <A2AA6D08-9506-4B41-9738-4D5FF8E2E011@illinois.edu>
<04D84259-1B75-4648-949F-78677916194E@jakobs.com>
Hi All
As soon as client session is established work_mem will be allocated or only when sort happens for that particular session? Please advise how the internal behavior? This will help me to configure my database memory with high connections
Regards
Sasi
Sent from Yahoo Mail on Android
On Wed, Mar 31, 2021 at 8:52 PM, Holger Jakobs<holger@jakobs.com> wrote: #yiv2643575322 #yiv2643575322 -- _filtered {} _filtered {} _filtered {}#yiv2643575322 #yiv2643575322 p.yiv2643575322MsoNormal, #yiv2643575322 li.yiv2643575322MsoNormal, #yiv2643575322 div.yiv2643575322MsoNormal {margin:0in;font-size:12.0pt;font-family:sans-serif;}#yiv2643575322 span.yiv2643575322EmailStyle17 {font-family:sans-serif;color:windowtext;}#yiv2643575322 .yiv2643575322MsoChpDefault {font-size:12.0pt;font-family:sans-serif;} _filtered {}#yiv2643575322 div.yiv2643575322WordSection1 {}#yiv2643575322 You can show any or all settings with the command SHOW.
show work_mem;
show all;
How many times the amount of work_mem has been allocated currently cannot be shown this way. Any sort operation running currently allocates it. So it is not identical with the number of current queries, because queries can allocate it several times.
Am 31. März 2021 16:04:07 MESZ schrieb "Campbell, Lance" <lance@illinois.edu>:
PostgreSQL 12
Is there a query that will tell us at any given time what amount of PostgreSQL memory is being used for work_mem?
Thanks,
LANCE CAMPBELL
Web Services
Public Affairs
Under the Illinois Freedom of Information Act any written communication to or from university employees regarding university business is a public record and may be subject to public disclosure.
--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -
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, holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: work_mem
In-Reply-To: <66290583.2329958.1617367063840@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