From owner-freebsd-questions Wed Nov 17 22: 2:19 1999 Delivered-To: freebsd-questions@freebsd.org Received: from fw.wintelcom.net (ns1.wintelcom.net [209.1.153.20]) by hub.freebsd.org (Postfix) with ESMTP id 2AF2114A09 for ; Wed, 17 Nov 1999 22:02:18 -0800 (PST) (envelope-from bright@wintelcom.net) Received: from localhost (bright@localhost) by fw.wintelcom.net (8.9.3/8.9.3) with ESMTP id WAA26780; Wed, 17 Nov 1999 22:28:26 -0800 (PST) Date: Wed, 17 Nov 1999 22:28:26 -0800 (PST) From: Alfred Perlstein To: Mike Tancsa Cc: questions@FreeBSD.ORG Subject: Re: Increasing disk cache In-Reply-To: <4.1.19991117234540.04c45e10@granite.sentex.ca> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Wed, 17 Nov 1999, Mike Tancsa wrote: > > I have a somewhat large postgres database on a server (currently about > 6gig). The data is only written to once a day, and otherwise is just read > the rest of the day. The machine has after running for a while shows > Mem: 23M Active, 99M Inact, 16M Wired, 8664K Cache, 8344K Buf, 40M Free > > Would it make sense to tune my kernel so that the disk cache is larger ? > If so, where would I tune this. We just 'tuned' postgres over here, what you might want to try is increasing the amount of shared memory in your kernel and tell postgresql to use it. options SHMMAXPGS=262144 options SHMSEG=32 this is for over 256MB of shared memory, you'll want a smaller value. try starting postmaster with higher and higher values for "-B N" we use -B 32768, but again, you'll probably want something smaller. -Alfred To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message