pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rick Apichairuk <rapichai@gmail.com>
To: pgsql-general@postgresql.org
Subject: Re: FreeBSD 5.2.1, postgresql 7.4.5 and shared memory settings
Date: Sun, 30 Jan 2005 16:26:29 -0500
Message-ID: <9776bb660501301326565859a3@mail.gmail.com> (raw)
In-Reply-To: <20050130205021.GA14588@guests.deus.net>
References: <9776bb66050130122122a3e342@mail.gmail.com>
	<20050130205021.GA14588@guests.deus.net>

On Sun, 30 Jan 2005 20:50:21 +0000, Richard Poole <rp@guests.deus.net> wrote:
> On Sun, Jan 30, 2005 at 03:21:25PM -0500, Rick Apichairuk wrote:
> 
> > I am trying to increase the number of max_connections to 200 and found
> > out I couldn't even start postgresql. So I tried to increase
> > max_connections gradually (currently at 50 from 40 default) and adjust
> > shared memory settings along the way. Even at 50 max_connections, I
> > still cannot get postgresql to start.
> >
> > The following is the error message I receive:
> >
> > pgsql FATAL:  could not create shared memory segment: Invalid argument
> > DETAIL:  Failed system call was shmget(key=5432001, size=35323904,
> > 03600).
> 
> > To reduce the request size (currently 35323904 bytes),
> 
> > kern.ipc.shmmax: 33554432
> 
> Looks like the request size is just higher than shmmax. The majority of
> the request is for the shared buffers, so if you can't increase shmmax
> any more you can reduce your shared buffers downwards from 4096 and this
> will give you some room for more connections.
> 
> 
> Richard
> 

Thanks... I missed that completely (need sleep!). I will try to bump
up my SHMMAXPGS from 262144 to 400000.

Is the shared_buffers per process? The reason I ask is the formula
given on http://www.postgresql.org/docs/7.4/static/kernel-resources.html
for calculating how much SHMMAX you need is:

SHMMAX = 250 kB + 8.2 kB * shared_buffers + 14.2 kB * max_connections
up to infinity

If it were per process (connection) shouldn't it be:

SHMMAX = (250 kB + 8.2 kB * shared_buffers + 14.2 kB) *
max_connections up to infinity

Also the examples for FreeBSD are:

options         SYSVSHM
options         SHMMAXPGS=4096
options         SHMSEG=256

options         SYSVSEM
options         SEMMNI=256
options         SEMMNS=512
options         SEMMNU=256
options         SEMMAP=256

How many connections is this supposed to support?

Thanks in advance.



view thread (12+ messages)  latest in thread

Message-ID: <9776bb660501301326565859a3@mail.gmail.com>
Permalink:  ../9776bb660501301326565859a3@mail.gmail.com/
Also on:    postgresql.org/message-id/9776bb660501301326565859a3@mail.gmail.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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: rapichai@gmail.com, pgsql-general@postgresql.org
  Subject: Re: FreeBSD 5.2.1, postgresql 7.4.5 and shared memory settings
  In-Reply-To: <9776bb660501301326565859a3@mail.gmail.com>
  References: <9776bb66050130122122a3e342@mail.gmail.com> <20050130205021.GA14588@guests.deus.net> <9776bb660501301326565859a3@mail.gmail.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