Re: "out of memory" error - Mailing list pgsql-general

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
asshared 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<dd>PostgreSQL uses lots of this, view <code>ipcs</code> to
proveit, the more shared memory the better as more data (tables) can be loaded. On a dedicated datbase server it's not
uncommonto give half the memory to the database.</dl></blockquote> and<br /><blockquote
type="cite"><dl><dt>shared_buffers= N<dd>Set anywhere from 1/4 to 1/2 physical memory, must set kernel shared memory
maxfirst. Will see noticeable difference.</dl></blockquote> Since the first links are also mentioned on the official
PostgreSQLwebsite (<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
trustedmore.<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>