Re: Kernel Resources and max_connections - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: Kernel Resources and max_connections
Date
Msg-id 42785AB4.5080206@paradise.net.nz
Whole thread Raw
In response to Re: Kernel Resources and max_connections  (Chris Hebrard <tech2@wildcash.com>)
List pgsql-performance
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







pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Kernel Resources and max_connections
Next
From: Mike Rylander
Date:
Subject: Re: