<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Il 14/04/2017 20:55, Melvin Davidson ha
scritto:<br>
</div>
<blockquote
cite="mid:CANu8FixEzCn3zYi_S6U8yV6OYE=1GYL19UhFdrY71vsdzz02OA(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 2:42 PM,
Chris Mair <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:chris(at)1006(dot)org" target="_blank">chris(at)1006(dot)org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex"><span
class="">
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
you should increase shared_memory to 40GB. General
philosphy is to allocate 80% of system memory to
shared_memory<br>
</blockquote>
<br>
</span>
Uhm...<br>
<br>
80% is too much, likely:<br>
<br>
<a moz-do-not-send="true"
href="https://www.postgresql.org/docs/9.5/static/runtime-config-resource.html"
rel="noreferrer" target="_blank">https://www.postgresql.org/doc<wbr>s/9.5/static/runtime-config-<wbr>resource.html</a><br>
<br>
Bye,<br>
Chris.<br>
<br>
<br>
</blockquote>
</div>
<br>
</div>
<div class="gmail_extra">Sorry, I had a brain fart,
shared_buffers should be 25% system memory, or 12GB<br>
</div>
</div>
</blockquote>
The original set was 13 GB (I lowered to 3 GB to take a test), but
probably I never acknowledged it with top...<br>
<blockquote
cite="mid:CANu8FixEzCn3zYi_S6U8yV6OYE=1GYL19UhFdrY71vsdzz02OA(at)mail(dot)gmail(dot)com"
type="cite">
<div dir="ltr">
<div class="gmail_extra"><br clear="all">
<br>
-- <br>
<div class="gmail_signature" data-smartmail="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>
