<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-15">
</head>
<body bgcolor="#FFFFFF" text="#000000">
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>
<x-row><br>
30085 postgres 20 0 <b>3370048</b> 156656 153876 S 6.7 0.3
0:00.20 postgres</x-row><br>
<x-row>29833 postgres 20 0 <b>3370000</b> 65260 62416 S 1.7 0.1
0:00.17 postgres </x-row><br>
<x-row></x-row><x-row>29632 postgres 20 0 <b>3372468</b> 11712 6028
S 0.7 0.0 0:00.60 postgres </x-row><x-row></x-row><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.<br>
Moreno.<br>
</body>
</html>