Re: Log levels for checkpoint/bgwriter monitoring - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Log levels for checkpoint/bgwriter monitoring
Date
Msg-id 23366.1173754916@sss.pgh.pa.us
Whole thread Raw
In response to Re: Log levels for checkpoint/bgwriter monitoring  (Greg Smith <gsmith@gregsmith.com>)
Responses Re: Log levels for checkpoint/bgwriter monitoring
List pgsql-hackers
Greg Smith <gsmith@gregsmith.com> writes:
> Here's what I get as statistics on the buffer pool after a 
> scan when the server is "happy", from a run with 20 clients:

> writes=38.3MB (8.2%) pinned+used=38.3MB (8.2%)
> dirty buffer usage count histogram:
> 0=0.1% 1=0.3% 2=26% 3=17% 4=21% 5+=36%

Interesting, but not real meaningful by itself --- what's the situation
for non-dirty buffers?  And how many are there of each?

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 ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: autovacuum next steps, take 3
Next
From: ITAGAKI Takahiro
Date:
Subject: Re: autovacuum next steps, take 3