view bc is just a joining wrapper around pg_buffercache.
regression=# select datname, relname, count(*), sum(count(*)) over () AS total from bc where isdirty group by datname, relname;
datname | relname | count | total
---------+---------+-------+-------
(0 rows)
regression=# update tenk1 set stringu1 = stringu1 || '' where (unique1 % 384) = 3;
UPDATE 27
regression=# select datname, relname, count(*), sum(count(*)) over () AS total from bc where isdirty group by datname, relname;
datname | relname | count | total
------------+---------+-------+-------
regression | tenk1 | 3 | 3
(1 row)
regression=# checkpoint;
CHECKPOINT
2022-04-19 23:17:08.256 UTC [161084] LOG: checkpoint starting: immediate force wait
2022-04-19 23:17:08.264 UTC [161084] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.002 s, total=0.009 s; sync files=2, longest=0.002 s, average=0.001 s; distance=12 kB, estimate=72358 kB
I've done this four times in a row and while the number of dirty buffers shown each time vary (see below) I see that "wrote N buffers" is always exactly one more than the total count of dirty buffers. I'm just curious if anyone has a quick answer for this unusual correspondence.
David J.
regression=# update tenk1 set stringu1 = stringu1 || '' where (unique1 % 384) = 3;
UPDATE 27
regression=# select datname, relname, count(*), sum(count(*)) over () AS total from bc where isdirty group by datname, relname;
datname | relname | count | total
------------+----------------------+-------+-------
regression | tenk1 | 33 | 102
regression | tenk1_hundred | 9 | 102
regression | tenk1_thous_tenthous | 18 | 102
regression | tenk1_unique1 | 27 | 102
regression | tenk1_unique2 | 15 | 102
(5 rows)
2022-04-19 23:13:03.480 UTC [161084] LOG: checkpoint starting: immediate force wait
2022-04-19 23:13:03.523 UTC [161084] LOG: checkpoint complete: wrote 103 buffers (0.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.004 s, sync=0.014 s, total=0.044 s; sync files=8, longest=0.008 s, average=0.002 s; distance=721 kB, estimate=110165 kB
