[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] shmmax 9.3
From:       Matheus de Oliveira <matioli.matheus () gmail ! com>
Date:       2013-12-17 17:29:15
Message-ID: CAJghg4+34QY1O_j7ze4Thehp8w1_67O3J0B+kP=CSEhaTMcvEw () mail ! gmail ! com
[Download RAW message or body]

On Tue, Dec 17, 2013 at 2:51 PM, dx k9 <bitsandbytes88@hotmail.com> wrote:

> Hi, we are building a 9.3 instance on CentOS with 32 GB of RAM.   What is
> the recommended value for SHMMAX the documentation was far less is needed
> but not exactly how much.   We used 25% of total memory < 9.3.   But what
> should we use now ?  5% of total memory or just 10 MB or 10 KB ?   Do we
> even need to mess with sysctl.conf?    The documentation table 17-1 shows
> just 1 kb is needed yet below under linux the example uses 17 GB of SHMMAX.
>   We will run several instances on one server.
>
>

At 9.3 the mechanism for shared memory allocation has changed. Now it uses
mmap(). And so, there is no more need to adjust the SHMMAX parameter (at
least not more than the 1KB).

So the answer to your question is basically that you don't need to mess
sysctl.conf anymore to change SHMMAX (at least not in CentOS). You still
may need to tweak there to change semaphores limits.

Best regards,
-- 
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres

[Attachment #3 (text/html)]

<div dir="ltr"><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Dec 17, \
2013 at 2:51 PM, dx k9 <span dir="ltr">&lt;<a \
href="mailto:bitsandbytes88@hotmail.com" \
target="_blank">bitsandbytes88@hotmail.com</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">


<div><div dir="ltr">Hi, we are building a 9.3 instance on CentOS with 32 GB of RAM.   \
What is the recommended value for SHMMAX the documentation was far less is needed but \
not exactly how much.   We used 25% of total memory &lt; 9.3.   But what should we \
use now ?  5% of total memory or just 10 MB or 10 KB ?   Do we even need to mess with \
sysctl.conf?    The documentation table 17-1 shows just 1 kb is needed yet below \
under linux the example uses 17 GB of SHMMAX.   We will run several instances on one \
server.  <br>

 <br></div></div></blockquote><div><br></div><div>At 9.3 the mechanism for shared \
memory allocation has changed. Now it uses mmap(). And so, there is no more need to \
adjust the SHMMAX parameter (at least not more than the 1KB).<br>

<br></div><div>So the answer to your question is basically that you don&#39;t need to \
mess sysctl.conf anymore to change SHMMAX (at least not in CentOS). You still may \
need to tweak there to change semaphores limits.<br> </div>
</div><br clear="all"></div><div class="gmail_extra">Best regards,<br></div><div \
class="gmail_extra">-- <br>Matheus de Oliveira<br>Analista de Banco de \
Dados<br>Dextra Sistemas - MPS.Br nível F!<br><a \
href="http://www.dextra.com.br/postgres/" \
target="_blank">www.dextra.com.br/postgres</a><br>

<br>
</div></div>



[prev in list] [next in list] [prev in thread] [next in thread]