Re: FreeBSD config - Mailing list pgsql-performance

From Vivek Khera
Subject Re: FreeBSD config
Date
Msg-id x7eksgv0ci.fsf@yertle.int.kciLink.com
Whole thread Raw
In response to FreeBSD config  (Dror Matalon <dror@zapatec.com>)
List pgsql-performance
>>>>> "DM" == Dror Matalon <dror@zapatec.com> writes:

DM> which brings me back to my question why not make Freebsd use more of its
DM> memory for disk caching and then tell postgres about it.

Because this is a painfully hard thing to do ;-(

It involves hacking a system header file and recompiling the kernel.
It is not a simple tunable.  It has side effects regarding some other
sizing parameter as well, but I don't recall the details.  Details
have been posted to this list at least once before by Sean Chittenden.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD  +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

pgsql-performance by date:

Previous
From: Dror Matalon
Date:
Subject: Re: FreeBSD config
Next
From: Richard Huxton
Date:
Subject: Re: Select-Insert-Query