From owner-freebsd-isp Thu Oct 11 1:11:46 2001 Delivered-To: freebsd-isp@freebsd.org Received: from ns1.infowest.com (ns1.infowest.com [204.17.177.10]) by hub.freebsd.org (Postfix) with ESMTP id 6463D37B403 for ; Thu, 11 Oct 2001 01:11:44 -0700 (PDT) Received: from there (unknown [208.186.107.143]) by ns1.infowest.com (Postfix) with SMTP id 65681212DA; Thu, 11 Oct 2001 02:11:43 -0600 (MDT) Content-Type: text/plain; charset="iso-8859-1" From: Samuel J.Greear Organization: GetMegabits, Inc. To: "Marcel Prisi" , "Wojciech Sobczuk" Subject: Re: PostgreSQL & shared memory Date: Fri, 12 Oct 2001 02:10:34 -0600 X-Mailer: KMail [version 1.3] Cc: "J. Goodleaf" , "BSD-ISP" References: <006001c1516b$db2637b0$8d01a8c0@gastroleader.com> <20011010144555.B28041@freebsd.hbz.pl> <006b01c1522b$7f9ad750$8d01a8c0@gastroleader.com> In-Reply-To: <006b01c1522b$7f9ad750$8d01a8c0@gastroleader.com> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <20011011081143.65681212DA@ns1.infowest.com> Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.org On Thursday 11 October 2001 02:05 am, Marcel Prisi wrote: > Hi ! > > Daniel's hint did not help at all as I already had tweaked those values > (thanks for his help anyway). The most important ones seem to be in the > kernel config, both SEMMNI and SEMMNS. With SEMMNI=256 and SEMMNS=512 (have > a look in my previous email for the other values) I could get about 400 > connections, which is enough. > PostgreSQL is configurable in that you can define how much shared memory it is to use. Try upping this, the default is rather small. Sam To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message