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

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: go for a script! / ex: PostgreSQL vs. MySQL
Дата
Msg-id 16266.45299.517752.465494@yertle.int.kciLink.com
обсуждение исходный текст
Ответ на Re: go for a script! / ex: PostgreSQL vs. MySQL  (Sean Chittenden <sean@chittenden.org>)
Ответы 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>)
Список pgsql-performance
>>>>> "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 по дате отправления:

Предыдущее
От: Seum-Lim Gan
Дата:
Сообщение: Re: Performance, vacuum and reclaiming space, fsm
Следующее
От: Shridhar Daithankar
Дата:
Сообщение: Re: Performance, vacuum and reclaiming space, fsm