From owner-freebsd-questions@FreeBSD.ORG Mon Oct 27 04:42:13 2003 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 50ABD16A4B3 for ; Mon, 27 Oct 2003 04:42:13 -0800 (PST) Received: from smtp.mailbox.co.uk (smtp.mailbox.co.uk [195.82.125.32]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4B52B43FDD for ; Mon, 27 Oct 2003 04:42:12 -0800 (PST) (envelope-from wayne@penguinpowered.org) Received: from [212.18.250.170] (helo=marvin.penguinpowered.org) by smtp.mailbox.co.uk with esmtp (Exim 3.36 #1) id 1AE6hG-0003DW-00 for freebsd-questions@freebsd.org; Mon, 27 Oct 2003 12:42:10 +0000 Received: by marvin.penguinpowered.org (Postfix, from userid 1001) id 261D315319; Mon, 27 Oct 2003 12:42:48 +0000 (GMT) Date: Mon, 27 Oct 2003 12:42:48 +0000 From: Wayne Pascoe To: freebsd-questions@freebsd.org Message-ID: <20031027124247.GD61438@marvin.penguinpowered.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.1i Sender: wayne@penguinpowered.org X-System: FreeBSD i386 with kernel 4.9-PRERELEASE Subject: PostgreSQL on FreeBSD X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 27 Oct 2003 12:42:13 -0000 Hi all, I'm trying to configure and tune postgresql on FreeBSD 4.9. We want to allow at least 128 concurrent connections but preferably 256. Looking at the documentation, we should be okay if we set the following in our kernel to achieve this: kern.ipc.somaxconn = 512 kern.ipc.shmall = 65536 kern.ipc.shmmni = 128 kern.ipc.semmni = 8 kern.ipc.semmns = 256 Now, I have three questions... 1. Why do we have to set these in the kernel ? Why does setting them in /etc/sysctl.conf or /etc/loader.conf not work ? 2. Is there a recommended list of settings that we should use in our kernel to allow 128 connections and 256 connections ? and lastly, 3. What is the impact on the rest of the system likely to be by setting aside this memory as shared memory ? Is it then no longer available to other applications like Apache and Exim ? Are there any other performance issues that we should be aware of ? Regards, -- Wayne Pascoe Be nice to your daemons.