Postgres Pro
Downloads
Home   >   mailing lists

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

From Vivek Khera
Subject Re: go for a script! / ex: PostgreSQL vs. MySQL
Date
Msg-id 16266.45299.517752.465494@yertle.int.kciLink.com
Whole thread Raw
In response to Re: go for a script! / ex: PostgreSQL vs. MySQL  (Sean Chittenden <sean@chittenden.org>)
Responses Re: go for a script! / ex: PostgreSQL vs. MySQL  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
Re: go for a script! / ex: PostgreSQL vs. MySQL  (Sean Chittenden <sean@chittenden.org>)
List pgsql-performance
Tree view 
>>>>> "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.

pgsql-performance by date:

Previous
From: Seum-Lim Gan
Date:
Subject: Re: Performance, vacuum and reclaiming space, fsm
Next
From: Shridhar Daithankar
Date:
Subject: Re: Performance, vacuum and reclaiming space, fsm