pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Laszlo Nagy <gandalf@shopzeus.com>
To: Peter Koczan <pjkoczan@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: SHMMAX problem - how much is needed?
Date: Tue, 13 Nov 2007 22:20:18 +0100
Message-ID: <473A1512.9060307@shopzeus.com> (raw)
In-Reply-To: <4544e0330711131308p62a78e84t4380df68d1624ef5@mail.gmail.com>
References: <473A0242.3070002@shopzeus.com>
	<4544e0330711131308p62a78e84t4380df68d1624ef5@mail.gmail.com>

Peter Koczan wrote:
>> Minimum shared mem:  140731400 bytes = 135.0 MB
>> Maximum shared mem:  268435456 bytes = 256.0 MB
>>
>> kern.ipc.shmmin="140731400"
>> kern.ipc.shmmax="268435456"
>>
>> Nov 13 20:46:19 neptunus postgres[669]: [1-2] DETAIL:  Failed system
>> call was shmget(key=5432001, size=21725184, 03600).
>>     
>
> The shared memory request, according to the error message, was for ~20
> MB, far less than the 135 MB minimum limit you put in the kernel.
>   
It means that I really did not know what it means. What are the 
disadvantages of reducing shmmin to one?

> You'll need to lower the limit or raise your request size, probably
> with regards to shared_buffers, as I think you're only allocating 2 MB
> to shared_buffers. You'll want to raise that on a production machine.
>   

I used shared_buffers=2048 which is 2048*8192 bytes = 16MB. The 
documentation tells that each buffer is 8K (more precisely, BLCKSZ) and 
it also tells that some thousand is good for a production environment.

shared_buffers (integer)

Sets the number of shared memory buffers used by the database server. 
The default is typically 1000, but may be less if your kernel settings 
will not support it (as determined during initdb). Each buffer is 8192 
bytes, unless a different value of BLCKSZ was chosen when building the 
server. This setting must be at least 16, as well as at least twice the 
value of max_connections 
<http://www.postgresql.org/docs/8.1/interactive/runtime-config-connection.html#GUC-MAX-CONNECTIONS;; 
however, settings significantly higher than the minimum are usually 
needed for good performance. Values of a few thousand are recommended 
for production installations. This option can only be set at server start.




Well, this is a test server and I'm using 4096 on a production server 
but now I'm confused. What should be a good value for this?

Thanks,

   Laszlo




view thread (6+ messages)  latest in thread

Message-ID: <473A1512.9060307@shopzeus.com>
Permalink:  ../473A1512.9060307@shopzeus.com/
Also on:    postgresql.org/message-id/473A1512.9060307@shopzeus.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: gandalf@shopzeus.com, pjkoczan@gmail.com
  Subject: Re: SHMMAX problem - how much is needed?
  In-Reply-To: <473A1512.9060307@shopzeus.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox