Re: Figuring out shared buffer pressure

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Figuring out shared buffer pressure
Дата
Msg-id 20120530175720.GB26894@momjian.us
обсуждение исходный текст
Ответ на Re: Figuring out shared buffer pressure  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: Figuring out shared buffer pressure  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-hackers
On Wed, May 30, 2012 at 10:38:10AM -0700, Jeff Janes wrote:
> 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 ?

The issue is that once a buffer is removed from the free list, it is
never returned to the free list.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: FailedAssertion("!(PrivateRefCount[i] == 0)", File: "bufmgr.c", Line: 1741
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Figuring out shared buffer pressure