From owner-freebsd-stable Wed Oct 10 2:26:10 2001 Delivered-To: freebsd-stable@freebsd.org Received: from ns1.crl.go.jp (ns1.crl.go.jp [133.243.3.1]) by hub.freebsd.org (Postfix) with ESMTP id 51E3937B403; Wed, 10 Oct 2001 02:26:01 -0700 (PDT) Received: from crlgw1.crl.go.jp ([133.243.18.250]) by ns1.crl.go.jp (8.11.6/3.7W) with ESMTP id f9A9PxU26529; Wed, 10 Oct 2001 18:25:59 +0900 (JST) Received: from cain.gsoft.com.au (localhost [127.0.0.1]) by crlgw1.crl.go.jp (8.11.6/8.11.6) with ESMTP id f9A9Pwl09821; Wed, 10 Oct 2001 18:25:58 +0900 (JST) Message-ID: X-Mailer: XFMail 1.5.0 on FreeBSD X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: <006001c1516b$db2637b0$8d01a8c0@gastroleader.com> Date: Thu, 11 Oct 2001 18:24:23 +0900 (JST) From: "Daniel O'Connor" To: Marcel Prisi Subject: RE: PostgreSQL & shared memory Cc: freebsd-stable@FreeBSD.ORG, freebsd-isp@FreeBSD.ORG Sender: owner-freebsd-stable@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On 10-Oct-2001 Marcel Prisi wrote: > about 400-500 connections to PostgreSQL ? What about shared memory & FreeBSD > kernel ? You can tune the shared memory/semaphore options in PGSQL using sysctl which may help you a bit.. ie -> [chowder 18:20] ~ > sysctl -a | grep shm kern.ipc.shmmax: 33554432 kern.ipc.shmmin: 1 kern.ipc.shmmni: 192 kern.ipc.shmseg: 128 kern.ipc.shmall: 8192 kern.ipc.shm_use_phys: 0 Also, man 7 tuning :) --- Daniel O'Connor software and network engineer for Genesis Software - http://www.gsoft.com.au "The nice thing about standards is that there are so many of them to choose from." -- Andrew Tanenbaum To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-stable" in the body of the message