Re: Effective Cache Size

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Effective Cache Size
Дата
Msg-id 6404.1093374443@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Effective Cache Size  (Darcy Buskermolen <darcy@wavefire.com>)
Список pgsql-hackers
Darcy Buskermolen <darcy@wavefire.com> writes:
> I was thinking of changing the way EFC is handled, having it retrived via code 
> (much the same way top does it) rather than relying on the user to specify 
> the value.  This value would then be checked/updated every so often.

Even assuming that you can portably find out how much RAM is going to
kernel cache (which I do not believe), how do you know how much of it
is getting used for Postgres data as opposed to everything else?

At the moment I think that manual handling is sufficient anyway.  This
is a relatively low-impact parameter and it doesn't seem too important
to try to get it dead on.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE
Следующее
От: Shahbaz Javeed
Дата:
Сообщение: Re: AT TIME ZONE