Date: Fri, 2 Apr 2021 12:37:43 +0000 (UTC)
From: SASIKUMAR Devaraj <sashikumard@yahoo.com>
Reply-To: SASIKUMAR Devaraj <sashikumard@yahoo.com>
To: holger@jakobs.com, Holger Jakobs <holger@jakobs.com>,
	pgsql-admin@lists.postgresql.org
Message-ID: <66290583.2329958.1617367063840@mail.yahoo.com>
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>
Subject: Re: work_mem
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_2329957_338903149.1617367063837"
Content-Length: 8471
Archived-At: 
 <https://www.postgresql.org/message-id/66290583.2329958.1617367063840%40mail.yahoo.com>
Precedence: bulk

------=_Part_2329957_338903149.1617367063837
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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 inter=
nal behavior? This will help me to configure my database memory with high c=
onnections
Regards
Sasi

Sent from Yahoo Mail on Android=20
=20
  On Wed, Mar 31, 2021 at 8:52 PM, Holger Jakobs<holger@jakobs.com> wrote: =
  #yiv2643575322 #yiv2643575322 -- _filtered {} _filtered {} _filtered {}#y=
iv2643575322 #yiv2643575322 p.yiv2643575322MsoNormal, #yiv2643575322 li.yiv=
2643575322MsoNormal, #yiv2643575322 div.yiv2643575322MsoNormal {margin:0in;=
font-size:12.0pt;font-family:sans-serif;}#yiv2643575322 span.yiv2643575322E=
mailStyle17 {font-family:sans-serif;color:windowtext;}#yiv2643575322 .yiv26=
43575322MsoChpDefault {font-size:12.0pt;font-family:sans-serif;} _filtered =
{}#yiv2643575322 div.yiv2643575322WordSection1 {}#yiv2643575322 You can sho=
w 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 b=
e shown this way. Any sort operation running currently allocates it. So it =
is not identical with the number of current queries, because queries can al=
locate it several times.


Am 31. M=C3=A4rz 2021 16:04:07 MESZ schrieb "Campbell, Lance" <lance@illino=
is.edu>:

PostgreSQL 12
=20
 =C2=A0
=20
Is there a query that will tell us at any given time what amount of Postgre=
SQL memory is being used for work_mem? =C2=A0
=20
 =C2=A0
=20
Thanks,
=20
 =C2=A0
=20
LANCE CAMPBELL
=20
 =C2=A0
=20
Web Services
=20
Public Affairs
=20
=C2=A0
=20
=C2=A0
=20

=20
=C2=A0
=20
Under the Illinois Freedom of Information Act any written communication to =
or from university employees regarding university business is a public reco=
rd and may be subject to public disclosure.
=20
 =C2=A0
=20

--=20
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -
 =20

------=_Part_2329957_338903149.1617367063837
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi All<div id=3D"yMail_cursorElementTracker_1617366854836"><br></div><div i=
d=3D"yMail_cursorElementTracker_1617366855066">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</div><div id=3D"y=
Mail_cursorElementTracker_1617367032932"><br></div><div id=3D"yMail_cursorE=
lementTracker_1617367033176">Regards</div><div id=3D"yMail_cursorElementTra=
cker_1617367039466"><br></div><div id=3D"yMail_cursorElementTracker_1617367=
039686">Sasi<br><br><div id=3D"ymail_android_signature"><a id=3D"ymail_andr=
oid_signature_link" href=3D"https://go.onelink.me/107872968?pid=3DInProduct=
&amp;c=3DGlobal_Internal_YGrowth_AndroidEmailSig__AndroidUsers&amp;af_wl=3D=
ym&amp;af_sub1=3DInternal&amp;af_sub2=3DGlobal_YGrowth&amp;af_sub3=3DEmailS=
ignature">Sent from Yahoo Mail on Android</a></div> <br> <blockquote style=
=3D"margin: 0 0 20px 0;"> <div style=3D"font-family:Roboto, sans-serif; col=
or:#6D00F6;"> <div>On Wed, Mar 31, 2021 at 8:52 PM, Holger Jakobs</div><div=
>&lt;holger@jakobs.com&gt; wrote:</div> </div> <div style=3D"padding: 10px =
0 0 20px; margin: 10px 0 0 0; border-left: 1px solid #6D00F6;"> <div id=3D"=
yiv2643575322"><style>#yiv2643575322 #yiv2643575322 --
=20
 _filtered {}
 _filtered {}
 _filtered {}
#yiv2643575322 =20
#yiv2643575322 p.yiv2643575322MsoNormal, #yiv2643575322 li.yiv2643575322Mso=
Normal, #yiv2643575322 div.yiv2643575322MsoNormal
=09{margin:0in;font-size:12.0pt;font-family:sans-serif;}
#yiv2643575322 span.yiv2643575322EmailStyle17
=09{font-family:sans-serif;color:windowtext;}
#yiv2643575322 .yiv2643575322MsoChpDefault
=09{font-size:12.0pt;font-family:sans-serif;}
 _filtered {}
#yiv2643575322 div.yiv2643575322WordSection1
=09{}
#yiv2643575322 </style><div>You can show any or all settings with the comma=
nd SHOW.<br clear=3D"none"><br clear=3D"none">show work_mem;<br clear=3D"no=
ne">show all;<br clear=3D"none"><br clear=3D"none">How many times the amoun=
t of work_mem has been allocated currently cannot be shown this way. Any so=
rt operation running currently allocates it. So it is not identical with th=
e number of current queries, because queries can allocate it several times.=
<br clear=3D"none"><br clear=3D"none"><br clear=3D"none"><div class=3D"yiv2=
643575322gmail_quote">Am 31. M=C3=A4rz 2021 16:04:07 MESZ schrieb "Campbell=
, Lance" &lt;lance@illinois.edu&gt;:<blockquote class=3D"yiv2643575322gmail=
_quote" style=3D"margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 20=
4, 204);padding-left:1ex;">

<div class=3D"yiv2643575322yqt3059387208" id=3D"yiv2643575322yqt10656"><div=
 class=3D"yiv2643575322WordSection1">
<p class=3D"yiv2643575322MsoNormal"><span style=3D"font-size:11.0pt;">Postg=
reSQL 12</span></p>=20
<p class=3D"yiv2643575322MsoNormal"><span style=3D"font-size:11.0pt;"> &nbs=
p;</span></p>=20
<p class=3D"yiv2643575322MsoNormal"><span style=3D"font-size:11.0pt;">Is th=
ere a query that will tell us at any given time what amount of PostgreSQL m=
emory is being used for work_mem? &nbsp;</span></p>=20
<p class=3D"yiv2643575322MsoNormal"><span style=3D"font-size:11.0pt;"> &nbs=
p;</span></p>=20
<p class=3D"yiv2643575322MsoNormal"><span style=3D"font-size:11.0pt;">Thank=
s,</span></p>=20
<p class=3D"yiv2643575322MsoNormal"><span style=3D"font-size:11.0pt;"> &nbs=
p;</span></p>=20
<p class=3D"yiv2643575322MsoNormal"><b><span style=3D"font-size:11.0pt;colo=
r:#13294B;text-transform:uppercase;"><a rel=3D"nofollow noopener noreferrer=
" shape=3D"rect" target=3D"_blank" href=3D"https://directory.illinois.edu/p=
erson/lance"><span style=3D"color:#0563C1;">LANCE CAMPBELL</span></a></span=
></b><span style=3D"font-size:11.0pt;color:black;"></span></p>=20
<p class=3D"yiv2643575322MsoNormal"><span style=3D"font-size:11.0pt;color:#=
13294B;"> &nbsp;</span></p>=20
<p class=3D"yiv2643575322MsoNormal"><span style=3D"font-size:11.0pt;color:#=
13294B;"><a rel=3D"nofollow noopener noreferrer" shape=3D"rect" target=3D"_=
blank" href=3D"https://webtools.illinois.edu/"><span style=3D"color:#0563C1=
;">Web Services</span></a></span><span style=3D"font-size:11.0pt;color:blac=
k;"></span></p>=20
<p class=3D"yiv2643575322MsoNormal"><span style=3D"font-size:11.0pt;color:#=
13294B;"><a rel=3D"nofollow noopener noreferrer" shape=3D"rect" target=3D"_=
blank" href=3D"https://publicaffairs.illinois.edu/"><span style=3D"color:#0=
563C1;">Public Affairs</span></a></span><span style=3D"font-size:11.0pt;col=
or:black;"></span></p>=20
<p class=3D"yiv2643575322MsoNormal"><span style=3D"font-size:11.0pt;color:b=
lack;">&nbsp;</span></p>=20
<p class=3D"yiv2643575322MsoNormal"><span style=3D"font-size:11.0pt;color:b=
lack;">&nbsp;</span></p>=20
<p class=3D"yiv2643575322MsoNormal"><a rel=3D"nofollow noopener noreferrer"=
 shape=3D"rect" target=3D"_blank" href=3D"http://illinois.edu/"><span style=
=3D"font-size:11.0pt;color:windowtext;text-decoration:none;"><img id=3D"yiv=
2643575322Picture_x0020_1" border=3D"0" width=3D"119" height=3D"21" style=
=3D"width:1.2395in;min-height:.2187in;" src=3D"" alt=3D"/var/folders/wp/1f6=
l7hw95y718z976kgnl5f9kr5rtc/T/com.microsoft.Outlook/WebArchiveCopyPasteTemp=
Files/signature_logo.png"></span></a><span style=3D"font-size:11.0pt;color:=
black;"></span></p>=20
<p class=3D"yiv2643575322MsoNormal"><span style=3D"font-size:13.5pt;font-fa=
mily:-webkit-standard;color:black;">&nbsp;</span><span style=3D"font-size:1=
1.0pt;"></span></p>=20
<p class=3D"yiv2643575322MsoNormal"><i><span style=3D"font-size:11.0pt;colo=
r:black;">Under the Illinois Freedom of Information Act any written communi=
cation to or from university employees regarding university business is a p=
ublic record and may be subject to public disclosure.</span></i><span style=
=3D"font-size:11.0pt;color:black;"></span></p>=20
<p class=3D"yiv2643575322MsoNormal"> &nbsp;</p>=20
</div></div>


</blockquote></div><br clear=3D"none">-- <br clear=3D"none">Holger Jakobs, =
Bergisch Gladbach<br clear=3D"none">+49 178 9759012<br clear=3D"none">- sen=
t from mobile, therefore short -<br clear=3D"none"></div></div> </div> </bl=
ockquote></div>
------=_Part_2329957_338903149.1617367063837--