X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.225.181]) by svr1.postgresql.org (Postfix) with ESMTP id E9252D1C50F for ; Mon, 21 Jul 2003 20:41:53 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr5.postgresql.org [64.117.225.181]) (amavisd-new, port 10024) with ESMTP id 22218-09 for ; Mon, 21 Jul 2003 20:41:42 +0000 (GMT) Received: from candle.pha.pa.us (momjian.navpoint.com [207.106.42.251]) by svr1.postgresql.org (Postfix) with ESMTP id 40F38D1C50D for ; Mon, 21 Jul 2003 17:41:41 -0300 (ADT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id h6LKfbi14090; Mon, 21 Jul 2003 16:41:37 -0400 (EDT) From: Bruce Momjian Message-Id: <200307212041.h6LKfbi14090@candle.pha.pa.us> Subject: Re: Tunning FreeeBSD and PostgreSQL In-Reply-To: To: Vivek Khera Date: Mon, 21 Jul 2003 16:41:37 -0400 (EDT) Cc: pgsql-performance@postgresql.org X-Mailer: ELM [version 2.4ME+ PL99 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/343 X-Sequence-Number: 2636 Vivek Khera wrote: > >>>>> "SH" == Stephen Howie writes: > > SH> Richard- > SH> That was very helpfull Thanks! > SH> I still would like some guidance on tunning FreeBSD (shmmax and shmmaxpgs). > SH> Do I need to even touch these settings? > > Here's what I use on FreeBSD 4.7/4.8. The kernel settings don't hurt > anything being too large for the SHM values, since they are limits, > not anything pre-allocated (from my understanding). These settings > allow for up to 100,000 shared buffers (I currently only use 30,000 > buffers) I think the only downside to making them too big is that you allocate page tables and prevent that address range from being used by other processes. Of course, if you have much less than 4 gigs of RAM in the machine, it probably isn't an issue. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073