| From: | Vivek Khera <khera(at)kcilink(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: go for a script! / ex: PostgreSQL vs. MySQL |
| Date: | 2003-10-13 14:04:35 |
| Message-ID: | 16266.45299.517752.465494@yertle.int.kciLink.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
>>>>> "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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2003-10-13 14:11:08 | Re: Performance weirdness with/without vacuum analyze |
| Previous Message | Harry Broomhall | 2003-10-13 13:47:20 | Performance weirdness with/without vacuum analyze |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2003-10-13 14:07:14 | Re: Performance, vacuum and reclaiming space, fsm |
| Previous Message | Seum-Lim Gan | 2003-10-13 13:52:05 | Re: Performance, vacuum and reclaiming space, fsm |