Re: Log levels for checkpoint/bgwriter monitoring

On Mon, 12 Mar 2007, Tom Lane wrote:

> It might also be interesting to know exactly how many buffers were
> pinned at the time the scan passed over them. In theory it should be a
> small fraction, but maybe it isn't ...

It is; the theory holds for all the tests I tried today. The actual
pinned buffers were so few (typically a fraction of the clients) that I
reverted to just lumping them in with the recently used ones. To better
reflect the vast majority of what it's interacting with, in my patch I
renamed the SyncOneBuffer "skip_pinned" to "skip_recently_used". It seems
natural that something currently pinned would also be considered recently
used, the current naming I didn't find so obvious.

I'm also now collecting clean vs. dirty usage histogram counts as well
since you suggested it. Nothing exciting to report there so far, may note
something interesting after I collect more data.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD