X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 962E0D1B91B for ; Thu, 26 Feb 2004 23:02:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 38950-03 for ; Thu, 26 Feb 2004 19:02:40 -0400 (AST) Received: from five.zapatec.com (66-117-150-100.web.lmi.net [66.117.150.100]) by svr1.postgresql.org (Postfix) with ESMTP id 42EFCD1B4AA for ; Thu, 26 Feb 2004 19:02:38 -0400 (AST) Received: from rlx11.zapatec.com (rlx11.pr.zapatec.com [192.168.1.132]) by five.zapatec.com (Postfix) with ESMTP id 92E665D23 for ; Thu, 26 Feb 2004 15:02:40 -0800 (PST) Received: (from dror@localhost) by rlx11.zapatec.com (8.12.3/8.12.3/Submit) id i1QN2edJ081029 for pgsql-performance@postgresql.org; Thu, 26 Feb 2004 15:02:40 -0800 (PST) (envelope-from dror) Date: Thu, 26 Feb 2004 15:02:40 -0800 From: Dror Matalon To: pgsql-performance@postgresql.org Subject: Re: FreeBSD config Message-ID: <20040226230240.GM26787@rlx11.zapatec.com> References: <20040227054639.H34315-100000@houston.familyhealth.com.au> <403E2071.31408.BAFBDDB@localhost> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <403E2071.31408.BAFBDDB@localhost> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/309 X-Sequence-Number: 5833 Thanks for the pointer. So maxbufspace = nbuf * BKVASIZE; Which is confirmed in http://unix.derkeiler.com/Mailing-Lists/FreeBSD/performance/2003-09/0045.html and it looks like there's a patch by Sean Chittenden at http://people.freebsd.org/~seanc/patches/patch-HEAD-kern.nbuf that does what I was asking. Seems a little on the bleeding edge. Has anyone tried this? On Thu, Feb 26, 2004 at 04:36:01PM -0600, Kevin Barnard wrote: > On 26 Feb 2004 at 13:58, Dror Matalon wrote: > > > > > which brings me back to my question why not make Freebsd use more of its > > memory for disk caching and then tell postgres about it. > > > > I think there is some confusion about maxbufsize and hibufspace. I looking at a > comment in the FreeBSB source 4.9 that explains this. I think you will want to > increase effective_cache to match maxbufsize not hibufspace but I could be wrong. > > $FreeBSD: src/sys/kern/vfs_bio.c,v 1.242.2.21 line 363 > -- Dror Matalon Zapatec Inc 1700 MLK Way Berkeley, CA 94709 http://www.fastbuzz.com http://www.zapatec.com