Skip site navigation (1) Skip section navigation (2)

FreeBSD config

From: Dror Matalon <dror(at)zapatec(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: FreeBSD config
Date: 2004-02-26 18:03:45
Message-ID: 20040226180345.GU26787@rlx11.zapatec.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hi,

We have postgres running on freebsd 4.9 with 2 Gigs of memory. As per
repeated advice on the mailing lists we configured effective_cache_size
= 25520 which you get by doing `sysctl -n vfs.hibufspace` / 8192

Which results in using 200Megs for disk caching. 

Is there a reason not to increase the hibufspace beyond the 200 megs and
provide a bigger cache to postgres? I looked both on the postgres and
freebsd mailing lists and couldn't find a good answer to this.

If yes, any suggestions on what would be a good size on a 2 Gig machine?

Regards,

Dror


-- 
Dror Matalon
Zapatec Inc 
1700 MLK Way
Berkeley, CA 94709
http://www.fastbuzz.com
http://www.zapatec.com

Responses

pgsql-performance by date

Next:From: scott.marloweDate: 2004-02-26 18:55:31
Subject: Re: FreeBSD config
Previous:From: scott.marloweDate: 2004-02-26 17:15:54
Subject: Re: A cache for the results of queries ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group