Date: Thu, 11 Oct 2001 10:31:02 +0200 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> Subject: Re: PostgreSQL & shared memory Message-ID: <009801c1522f$106a5870$8d01a8c0@gastroleader.com> References: <006001c1516b$db2637b0$8d01a8c0@gastroleader.com> <20011010144555.B28041@freebsd.hbz.pl> <006b01c1522b$7f9ad750$8d01a8c0@gastroleader.com> <20011011081143.65681212DA@ns1.infowest.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?009801c1522f$106a5870$8d01a8c0>