| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2004-02-26 18:55:31 | Re: FreeBSD config |
| Previous Message | scott.marlowe | 2004-02-26 17:15:54 | Re: A cache for the results of queries ? |