Date: Fri, 12 Oct 2001 03:27:06 -0600 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> Subject: Re: PostgreSQL & shared memory Message-ID: <20011011092815.C231621026@ns1.infowest.com> In-Reply-To: <009801c1522f$106a5870$8d01a8c0@gastroleader.com> References: <006001c1516b$db2637b0$8d01a8c0@gastroleader.com> <20011011081143.65681212DA@ns1.infowest.com> <009801c1522f$106a5870$8d01a8c0@gastroleader.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20011011092815.C231621026>