On 11/2/21 20:02, Tom Lane wrote:
My objection to log_checkpoints=on is that that's going to produce a constant stream of messages even when *nothing at all* is wrong. Worse yet, a novice DBA would likely have a hard time understanding from those messages whether there was anything to worry about or not. If we could design a variant of log_checkpoints that would produce output only when the situation really needs attention, I'd be fine with enabling that by default.
Making log_checkpoints an enum sort of thing as already suggested might do that. Or (also already suggested) elevating checkpoint logging once it happened because of WAL for a while.
The thing I don't want to see us doing is *nothing at all* when pretty much everyone with some customer experience in the field is saying "this is the information we want to see post incident and nobody has it so we sit there waiting for the next time it happens."
Regards -- Jan Wieck
