From: Tom Lane <tgl@sss.pgh.pa.us>
To: stuart@comodo.net
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] SOMAXCONN, MaxBackendID and Postgres
Date: Tue, 27 Jul 1999 10:28:33 -0400
Message-ID: <7018.933085713@sss.pgh.pa.us> (raw)
In-Reply-To: <99072710572500.00398@kevin>
StOo <stuart@comodo.net> writes:
> O/S S.u.s.e linux 6.0
> kernel 2.0.36
> postgres 6-4-2
> I'm trying to increase the maximum number of connections on the operating
> system which invovles altering the SOMAXCONN and patching certain
> files.
Changing the max number of backends in 6.4.* is pretty painful. I'd
suggest updating to 6.5.1 --- you can set the max to as high as 1024
without even recompiling.
Whether your kernel will support that many is another question. Aside
from the connections themselves, you need adequate swap space, file
table slots, etc to support that many processes. You will also need
larger-than-typical limits on the size of the shared memory block and
on the max number of semaphores.
regards, tom lane
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-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, stuart@comodo.net
Subject: Re: [INTERFACES] SOMAXCONN, MaxBackendID and Postgres
In-Reply-To: <7018.933085713@sss.pgh.pa.us>
* 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