From owner-freebsd-isp  Thu Oct 11  1:32:44 2001
Delivered-To: freebsd-isp@freebsd.org
Received: from xor.aubonne.virtua.ch (virtua.sefanet.ch [195.202.225.253])
	by hub.freebsd.org (Postfix) with ESMTP id 00A6437B40A
	for <freebsd-isp@FreeBSD.ORG>; Thu, 11 Oct 2001 01:32:40 -0700 (PDT)
Received: from RATAMIAOU ([192.168.1.141])
	by xor.aubonne.virtua.ch (8.9.3/8.8.7) with SMTP id KAA09395;
	Thu, 11 Oct 2001 10:31:37 +0200
Message-ID: <009801c1522f$106a5870$8d01a8c0@gastroleader.com>
From: "Marcel Prisi" <marcel-lists@virtua.ch>
To: "Samuel J.Greear" <dragonk@evilcode.net>,
	"Wojciech Sobczuk" <sopel@freebsd.hbz.pl>
Cc: "J. Goodleaf" <john@goodleaf.net>,
	"BSD-ISP" <freebsd-isp@FreeBSD.ORG>
References: <006001c1516b$db2637b0$8d01a8c0@gastroleader.com> <20011010144555.B28041@freebsd.hbz.pl> <006b01c1522b$7f9ad750$8d01a8c0@gastroleader.com> <20011011081143.65681212DA@ns1.infowest.com>
Subject: Re: PostgreSQL & shared memory
Date: Thu, 11 Oct 2001 10:31:02 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Sender: owner-freebsd-isp@FreeBSD.ORG
Precedence: bulk
List-ID: <freebsd-isp.FreeBSD.ORG>
List-Archive: <http://docs.freebsd.org/mail/> (Web Archive)
List-Help: <mailto:majordomo@FreeBSD.ORG?subject=help> (List Instructions)
List-Subscribe: <mailto:majordomo@FreeBSD.ORG?subject=subscribe%20freebsd-isp>
List-Unsubscribe: <mailto:majordomo@FreeBSD.ORG?subject=unsubscribe%20freebsd-isp>
X-Loop: FreeBSD.org

Hi !

I did some trys at upping the shared memory allowed to PostgreSQL (anyway,
if you want to up the number of connections you HAVE to up the shared memory
as every connection uses LOADS of shared memory).

I had to try and add some connections up to when Postgres tells me there is
not enough shared memory on the system.

BTW, is there a way to know how much shared memory is used/free on a FreeBSD
system ? On newer linux, shared memory is mounted as another filesystem, so
you can use df / mount to have some ideas :-)

Thanks for your help.
----- Original Message -----
From: "Samuel J.Greear" <dragonk@evilcode.net>
To: "Marcel Prisi" <marcel-lists@virtua.ch>; "Wojciech Sobczuk"
<sopel@freebsd.hbz.pl>
Cc: "J. Goodleaf" <john@goodleaf.net>; "BSD-ISP" <freebsd-isp@FreeBSD.ORG>
Sent: Friday, October 12, 2001 10:10 AM
Subject: Re: PostgreSQL & shared memory


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