This is a discussion on Re: bgwriter stats within the Pgsql Patches forums, part of the PostgreSQL category; --> "Magnus Hagander" <magnus@hagander.net> writes: >> This seems quite a bizarre way to do things. Why wouldn't you implement >> ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| "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 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 |