From: Vivek Khera <khera@kcilink.com>
To: pgsql-performance@postgresql.org
Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL
Date: Mon, 13 Oct 2003 10:04:35 -0400
Message-ID: <16266.45299.517752.465494@yertle.int.kciLink.com> (raw)
In-Reply-To: <20031011092308.GA39942@perrin.nxad.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>
>>>>> "SC" == Sean Chittenden <sean@chittenden.org> writes:
>> 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? It appears to me that even on my 2Gb
box, lots of memory is 'free' that could be used for the cache
(bumping up shared buffers is another option...) yet the disk is being
highly utilized according to systat.
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: khera@kcilink.com
Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL
In-Reply-To: <16266.45299.517752.465494@yertle.int.kciLink.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