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

Поиск
Список
Период
Сортировка
От Shridhar Daithankar
Тема Re: go for a script! / ex: PostgreSQL vs. MySQL
Дата
Msg-id 200310131944.55273.shridhar_daithankar@persistent.co.in
обсуждение исходный текст
Ответ на Re: go for a script! / ex: PostgreSQL vs. MySQL  (Vivek Khera <khera@kcilink.com>)
Список 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 по дате отправления:

Предыдущее
От: Shridhar Daithankar
Дата:
Сообщение: Re: Performance, vacuum and reclaiming space, fsm
Следующее
От: Joe Conway
Дата:
Сообщение: Re: Another weird one with an UPDATE