From: MichaelDBA <MichaelDBA@sqlexec.com>
To: SASIKUMAR Devaraj <sashikumard@yahoo.com>
Cc: holger@jakobs.com
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: work_mem
Date: Fri, 2 Apr 2021 08:39:18 -0400
Message-ID: <c1e02a03-71cd-4071-e000-967403bcab9d@sqlexec.com> (raw)
In-Reply-To: <66290583.2329958.1617367063840@mail.yahoo.com>
References: <A2AA6D08-9506-4B41-9738-4D5FF8E2E011@illinois.edu>
<04D84259-1B75-4648-949F-78677916194E@jakobs.com>
<66290583.2329958.1617367063840@mail.yahoo.com>
Memory is allocated dynamically per internal work_mem buffer requests.
SASIKUMAR Devaraj wrote on 4/2/2021 8:37 AM:
> 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
> <https://go.onelink.me/107872968?pid=InProduct&c=Global_Internal_YGrowth_AndroidEmailSig__Android...;
>
> On Wed, Mar 31, 2021 at 8:52 PM, Holger Jakobs
> <holger@jakobs.com> wrote:
> 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 <https://directory.illinois.edu/person/lance>*
>
> Web Services <https://webtools.illinois.edu/;
>
> Public Affairs <https://publicaffairs.illinois.edu/;
>
> /var/folders/wp/1f6l7hw95y718z976kgnl5f9kr5rtc/T/com.microsoft.Outlook/WebArchiveCopyPasteTempFiles/signature_logo.png
> <http://illinois.edu/;
>
> /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: MichaelDBA@sqlexec.com, sashikumard@yahoo.com, holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: work_mem
In-Reply-To: <c1e02a03-71cd-4071-e000-967403bcab9d@sqlexec.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