Re: bgwriter stats - Mailing list pgsql-patches

From Tom Lane
Subject Re: bgwriter stats
Date
Msg-id 5384.1174374526@sss.pgh.pa.us
Whole thread Raw
In response to bgwriter stats  (Magnus Hagander <magnus@hagander.net>)
List pgsql-patches
"Magnus Hagander" <magnus@hagander.net> writes:
>> This seems quite a bizarre way to do things.  Why wouldn't you implement
>> this functionality by shipping messages to the stats collector?

> Would you suggest doing the same with the checkpoint counter, that's already in shared mem? I want to expose that
numberas well.. 

The shared-mem checkpoint counters serve an entirely different purpose:
they're there to let backends detect when their requested checkpoint has
been completed.  They're not intended to count checkpoints over any
long term (remember that sig_atomic_t need only be 8 bits wide).

If you want to track stats about how many checkpoints have been done,
I think that's a job for the stats collector.

            regards, tom lane

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: bgwriter stats
Next
From: Magnus Hagander
Date:
Subject: Re: Win32 shmem