Re: go for a script! / ex: PostgreSQL vs. MySQL

From: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: Vivek Khera <khera(at)kcilink(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL
Date: 2003-10-13 14:14:55
Message-ID: 200310131944.55273.shridhar_daithankar@persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

On Monday 13 October 2003 19:34, Vivek Khera wrote:
> >>>>> "SC" == Sean Chittenden <sean(at)chittenden(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Harry Broomhall 2003-10-13 14:21:46 Re: Performance weirdness with/without vacuum analyze
Previous Message Jan Wieck 2003-10-13 14:11:15 Re: Unique Index vs. Unique Constraint

Browse pgsql-performance by date

  From Date Subject
Next Message ingrim 2003-10-13 14:38:25 unsuscribe mailing list
Previous Message Shridhar Daithankar 2003-10-13 14:07:14 Re: Performance, vacuum and reclaiming space, fsm