<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Sorry,<br>
my mistake (I'm a bit nervous...)<br>
<br>
that's not work_mem, but shared_buffers<br>
<br>
Thanks<br>
<br>
Il 14/04/2017 19:33, Melvin Davidson ha scritto:<br>
</div>
<blockquote
cite="mid:CANu8Fixpu_dOGR674jXCPO3TD_q08gbXpCB9hQM1tEWzGKSP6g(at)mail(dot)gmail(dot)com"
type="cite">
<div dir="ltr"><br>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Fri, Apr 14, 2017 at 1:12 PM,
Moreno Andreo <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:moreno(dot)andreo(at)evolu-s(dot)it" target="_blank">moreno(dot)andreo(at)evolu-s(dot)it</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF"> Hi all,<br>
About 2 hours and half ago, suddenly (and on the late
afternoon of the Easter Friday), customers reported
failing connections to our server, or even very slow.<br>
After a bit of checking (that also involved server
reboot) I noticed (using top) that every process
regarding postgres is using exactly the amout I
configured as work_mem (3 GB). And AFAIK it's not good.<br>
<br>
30085 postgres 20 0 <b>3370048</b> 156656 153876 S 6.7
0.3 0:00.20 postgres<br>
29833 postgres 20 0 <b>3370000</b> 65260 62416 S 1.7
0.1 0:00.17 postgres <br>
29632 postgres 20 0 <b>3372468</b> 11712 6028 S 0.7 0.0
0:00.60 postgres <br>
<br>
What can be happened?<br>
Nothing has been touched....<br>
postgresql 9.5.6 on debian 8 just apt-get upgrade'd<br>
<br>
Any help would be appreciated.<span class="gmail-HOEnZb"><font
color="#888888"><br>
Moreno.<br>
</font></span></div>
</blockquote>
</div>
<br>
<b>>using exactly the amout I configured as work_mem (3
GB).<br>
<br>
</b></div>
<div class="gmail_extra"><b>You are right, that is bad, but that
is your own fault. 3GB of work_mem is very bad, Try lowing
in to something more reasonable, like 20GB.<br>
<br clear="all">
</b></div>
<div class="gmail_extra"><b><a moz-do-not-send="true"
href="https://www.postgresql.org/docs/9.5/static/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-MEMORY">https://www.postgresql.org/docs/9.5/static/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-MEMORY</a><br>
"several running sessions could be doing such operations
concurrently. <span style="color:rgb(255,0,0)">Therefore,
the total memory used could be many times the value of <tt
class="gmail-VARNAME">work_mem</tt>;</span> it is
necessary to keep this fact in mind when choosing the
value."</b></div>
<div class="gmail_extra"><br>
-- <br>
<div class="gmail_signature">
<div dir="ltr"><font size="4"><b><span
style="font-family:courier new,monospace">Melvin
Davidson</span></b></font><br>
<font style="font-weight:bold" size="3"><span
style="color:rgb(128,0,255)">I reserve the right to
fantasize. Whether or not you </span><br
style="color:rgb(128,0,255)">
<span style="color:rgb(128,0,255)">wish to share my
fantasy is entirely up to you. </span><img
moz-do-not-send="true" style="color: rgb(128, 0,
255);"
src="http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif"></font><br>
</div>
</div>
</div>
</div>
</blockquote>
<p><br>
</p>
</body>
</html>
