Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] SOMAXCONN, MaxBackendID and Postgres

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: stuart(at)comodo(dot)net
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] SOMAXCONN, MaxBackendID and Postgres
Date: 1999-07-27 14:28:33
Message-ID: 7018.933085713@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-interfaces
StOo <stuart(at)comodo(dot)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

pgsql-interfaces by date

Next:From: Herouth MaozDate: 1999-07-27 14:36:09
Subject: Re: [INTERFACES] How can I work thru this key problem?
Previous:From: Tom LaneDate: 1999-07-27 14:22:22
Subject: Re: [INTERFACES] libpq problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group