Re: Figuring out shared buffer pressure

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Figuring out shared buffer pressure
Дата
Msg-id CAMkU=1zysj38SRuDKtSngUuHZEUqfvFriYAKN+RNrRpHPSZeBw@mail.gmail.com
обсуждение исходный текст
Ответ на Figuring out shared buffer pressure  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Figuring out shared buffer pressure  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
On Wed, May 30, 2012 at 9:56 AM, Bruce Momjian <bruce@momjian.us> wrote:
> As part of a blog, I started looking at how a user could measure the
> pressure on shared buffers, e.g. how much are they being used, recycled,
> etc.
>
> They way you normally do it on older operating systems is to see how
> many buffers on the free list (about to be reused) are reclaimed as
> needed --- that usually indicates kernel cache pressure.  Unfortunately,
> we don't have a freelist, except for initial assignment of shared
> buffers on startup.

Isn't that what the buffers_alloc from pg_stat_bgwriter is ?

Cheers,

Jeff


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: 9.2beta1, parallel queries, ReleasePredicateLocks, CheckForSerializableConflictIn in the oprofile
Следующее
От: Robert Haas
Дата:
Сообщение: Re: FailedAssertion("!(PrivateRefCount[i] == 0)", File: "bufmgr.c", Line: 1741