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 63BE8D1E2B1 for ; Thu, 26 Feb 2004 22:41:23 +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 33969-02 for ; Thu, 26 Feb 2004 18:41:04 -0400 (AST) Received: from mail.ez3pl.com (66-136-75-131.ded.swbell.net [66.136.75.131]) by svr1.postgresql.org (Postfix) with ESMTP id 7570AD1E152 for ; Thu, 26 Feb 2004 18:40:50 -0400 (AST) Received: from kbarnard ([172.25.96.149]) by mail.ez3pl.com (8.11.2/8.11.2) with ESMTP id i1QMdlo15993 for ; Thu, 26 Feb 2004 16:39:47 -0600 From: "Kevin Barnard" To: pgsql-performance@postgresql.org Date: Thu, 26 Feb 2004 16:36:01 -0600 MIME-Version: 1.0 Subject: Re: FreeBSD config Message-ID: <403E2071.31408.BAFBDDB@localhost> In-reply-to: <20040226215838.GK26787@rlx11.zapatec.com> References: <20040227054639.H34315-100000@houston.familyhealth.com.au> X-mailer: Pegasus Mail for Windows (v4.12a) Content-type: Multipart/Alternative; boundary="Alt-Boundary-9753.196066779" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/307 X-Sequence-Number: 5831 --Alt-Boundary-9753.196066779 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body 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 --Alt-Boundary-9753.196066779 Content-type: text/html; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body
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
--Alt-Boundary-9753.196066779--