Re: work_mem

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__AndroidUsers&af_wl=ym&af_sub1=Internal&af_sub2=Global_YGrowth&af_sub3=EmailSignature>
>
> On Wed, Mar 31, 2021 at 8:52 PM, Holger Jakobs
> <holger(at)jakobs(dot)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(at)illinois(dot)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 -
>