"Magnus Hagander" <[EMAIL PROTECTED]> 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 number as 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match