Re: go for a script! / ex: PostgreSQL vs. MySQL - Mailing list pgsql-performance

From Shridhar Daithankar
Subject Re: go for a script! / ex: PostgreSQL vs. MySQL
Date
Msg-id 200310131944.55273.shridhar_daithankar@persistent.co.in
Whole thread Raw
In response to Re: go for a script! / ex: PostgreSQL vs. MySQL  (Vivek Khera <khera@kcilink.com>)
List pgsql-performance
On Monday 13 October 2003 19:34, Vivek Khera wrote:
> >>>>> "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.

Is this of any help?..reverse video sucks though.. especially spec'ed person
like me..

http://unix.derkeiler.com/Mailing-Lists/FreeBSD/performance/2003-07/0073.html

 Shridhar


pgsql-performance by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: Performance, vacuum and reclaiming space, fsm
Next
From: Joe Conway
Date:
Subject: Re: Another weird one with an UPDATE