From: Sean Chittenden <sean@chittenden.org>
To: Vivek Khera <khera@kcilink.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL
Date: Mon, 13 Oct 2003 12:04:46 -0700
Message-ID: <20031013190446.GA72842@perrin.nxad.com> (raw)
In-Reply-To: <16266.45299.517752.465494@yertle.int.kciLink.com>
References: <007901c38f2b$0b585590$2802a8c0@webbased10>
<200310101034.52073.josh@agliodbs.com>
<3F86F5BB.90605@chuckie.co.uk>
<x7wubcon3h.fsf@yertle.int.kciLink.com>
<3F87932B.4050507@familyhealth.com.au>
<20031011092308.GA39942@perrin.nxad.com>
<16266.45299.517752.465494@yertle.int.kciLink.com>
> >> echo "effective_cache_size = $((`sysctl -n vfs.hibufspace` / 8192))"
> >>
> >> I've used it for my dedicated servers. Is this calculation correct?
>
> SC> Yes, or it's real close at least. vfs.hibufspace is the amount
> of SC> kernel space that's used for caching IO operations (minus the
>
> I'm just curious if anyone has a tip to increase the amount of
> memory FreeBSD will use for the cache?
Recompile your kernel with BKVASIZE set to 4 times its current value
and double your nbuf size. According to Bruce Evans:
"Actually there is a way: the vfs_maxbufspace gives the amount of
space reserved for buffer kva (= nbuf * BKVASIZE). nbuf is easy to
recover from this, and the buffer kva space may be what is wanted
anyway."
[snip]
"I've never found setting nbuf useful, however. I want most
parametrized sizes including nbuf to scale with resource sizes, and
it's only with RAM sizes of similar sizes to the total virtual address
size that its hard to get things to fit. I haven't hit this problem
myself since my largest machine has only 1GB. I use an nbuf of
something like twice the default one, and a BKVASIZE of 4 times the
default. vfs.maxbufspace ends up at 445MB on the machine with 1GB, so
it is maxed out now."
YMMV.
-sc
--
Sean Chittenden
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sean@chittenden.org, khera@kcilink.com
Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL
In-Reply-To: <20031013190446.GA72842@perrin.nxad.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox