<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Mikko Partio wrote:
<blockquote type="cite">
<div>
<div>Isn't 128MB quite low considering the "current standard" of 25%
- 50% of total ram?<br>
</div>
</div>
</blockquote>
<br>
I had also read a statement about using this amount of memory as shared
buffers. Exactly that was the reason why I set it to such a high value,
but I am now convinced that this is wrong.<br>
<br>
<a class="moz-txt-link-freetext" href="http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html#shbuf">http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html#shbuf</a><br>
and<br>
<a class="moz-txt-link-freetext" href="http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html">http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html</a><br>
are quite clear about this.<br>
<br>
On the other hand,
<a class="moz-txt-link-freetext" href="http://edoceo.com/liber/db-postgresql-performance.php">http://edoceo.com/liber/db-postgresql-performance.php</a> says:<br>
<blockquote type="cite">
<dl>
<dt>Shared Memory</dt>
<dd>PostgreSQL uses lots of this, view <code>ipcs</code> to prove
it, the more shared memory the better as more data (tables) can be
loaded.
On a dedicated datbase server it's not uncommon to give half the memory
to the database.</dd>
</dl>
</blockquote>
and<br>
<blockquote type="cite">
<dl>
<dt>shared_buffers = N</dt>
<dd>Set anywhere from 1/4 to 1/2 physical memory, must set kernel
shared memory max first.
Will see noticeable difference.</dd>
</dl>
</blockquote>
Since the first links are also mentioned on the official PostgreSQL
website (<a class="moz-txt-link-freetext" href="http://www.postgresql.org/docs/techdocs.2">http://www.postgresql.org/docs/techdocs.2</a>) I think they should
be trusted more.<br>
<br>
Regards,<br>
Christian<br>
<pre class="moz-signature" cols="72">--
Deriva GmbH Tel.: +49 551 489500-42
Financial IT and Consulting Fax: +49 551 489500-91
Hans-Böckler-Straße 2 <a class="moz-txt-link-freetext" href="http://www.deriva.de">http://www.deriva.de</a>
D-37079 Göttingen
Deriva CA Certificate: <a class="moz-txt-link-freetext" href="http://www.deriva.de/deriva-ca.cer">http://www.deriva.de/deriva-ca.cer</a></pre>
</body>
</html>