From owner-freebsd-isp  Thu Oct 11  2:28:20 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 155F037B405
	for <freebsd-isp@FreeBSD.ORG>; Thu, 11 Oct 2001 02:28:17 -0700 (PDT)
Received: from there (unknown [208.186.107.143])
	by ns1.infowest.com (Postfix) with SMTP
	id C231621026; Thu, 11 Oct 2001 03:28:15 -0600 (MDT)
Content-Type: text/plain;
  charset="iso-8859-1"
From: Samuel J.Greear <dragonk@evilcode.net>
Organization: GetMegabits, Inc.
To: "Marcel Prisi" <marcel-lists@virtua.ch>,
	"Wojciech Sobczuk" <sopel@freebsd.hbz.pl>
Subject: Re: PostgreSQL & shared memory
Date: Fri, 12 Oct 2001 03:27:06 -0600
X-Mailer: KMail [version 1.3]
Cc: "J. Goodleaf" <john@goodleaf.net>,
	"BSD-ISP" <freebsd-isp@FreeBSD.ORG>
References: <006001c1516b$db2637b0$8d01a8c0@gastroleader.com> <20011011081143.65681212DA@ns1.infowest.com> <009801c1522f$106a5870$8d01a8c0@gastroleader.com>
In-Reply-To: <009801c1522f$106a5870$8d01a8c0@gastroleader.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Message-Id: <20011011092815.C231621026@ns1.infowest.com>
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

On Thursday 11 October 2001 02:31 am, Marcel Prisi wrote:
> 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.
>


http://www.postgresql.org/idocs/index.php?kernel-resources.html
  ^---   one of those 'must reads' (if you haven't)  ..

and ipcs -a will give you pretty much all you need to know
about shared memory currently in use.

Sam





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