Re: FreeBSD config - Mailing list pgsql-performance

From Kevin Barnard
Subject Re: FreeBSD config
Date
Msg-id 403E2071.31408.BAFBDDB@localhost
Whole thread Raw
In response to Re: FreeBSD config  (Dror Matalon <dror@zapatec.com>)
Responses Re: FreeBSD config  (Dror Matalon <dror@zapatec.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Dror Matalon
Date:
Subject: Re: FreeBSD config
Next
From: Josh Berkus
Date:
Subject: Re: Database Server Tuning