pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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









view thread (5+ messages)

Message-ID: <42785AB4.5080206@paradise.net.nz>
Permalink:  ../42785AB4.5080206@paradise.net.nz/
Also on:    postgresql.org/message-id/42785AB4.5080206@paradise.net.nz

 · 

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 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