From: Mark Kirkwood <markir@paradise.net.nz>
To: Chris Hebrard <tech2@wildcash.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Kernel Resources and max_connections
Date: Wed, 04 May 2005 17:16:36 +1200
Message-ID: <42785AB4.5080206@paradise.net.nz> (raw)
In-Reply-To: <42782DA5.70701@wildcash.com>
References: <42782194.7040500@wildcash.com>
<4278297A.1010703@paradise.net.nz>
<42782DA5.70701@wildcash.com>
Chris Hebrard wrote:
>
> I set the values in etc/sysctl.conf:
>
> # $FreeBSD: src/etc/sysctl.conf,v 1.1.2.3 2002/04/15 00:44:13 dougb Exp $
> #
> # This file is read when going to multi-user and its contents piped thru
> # ``sysctl'' to adjust kernel values. ``man 5 sysctl.conf'' for details.
> #
> # Added by IMP 2005-05-04
> net.inet.tcp.rfc1323=1
> kern.ipc.somaxconn=1024
> kern.ipc.maxsockbuf=8388608
> net.inet.tcp.sendspace=3217968
> net.inet.tcp.recvspace=3217968
> kern.ipc.semmns="272"
> kern.ipc.semmni="256"
> kern.ipc.shmmax="66099200"
> kern.ipc.shmmin="256"
>
>
> After a restart both shmmax and shmmin are now 0 and postgres failed to
> start.
>
>
Hmmm - puzzling. One point to check, did you take them out of
/boot/loader.conf ?
Assuming so, maybe don't quote 'em (see below).
Finally you need to to set shmall, otherwise it will over(under)ride the
shmmax setting. So try:
net.inet.tcp.rfc1323=1
kern.ipc.somaxconn=1024
kern.ipc.maxsockbuf=8388608
net.inet.tcp.sendspace=3217968
net.inet.tcp.recvspace=3217968
kern.ipc.semmns=272
kern.ipc.semmni=256
kern.ipc.shmmax=66099200
kern.ipc.shmmin=256
kern.ipc.shmall=32768
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-performance@postgresql.org
Cc: markir@paradise.net.nz, tech2@wildcash.com
Subject: Re: Kernel Resources and max_connections
In-Reply-To: <42785AB4.5080206@paradise.net.nz>
* 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