On Fri May 30, 2025 at 1:55 PM CEST, David Rowley wrote:
By my count, those who think we should change log_buffers to true are: Robert [1], Michael Christofides [2], Fujii [3].
+1 for me on changing the default. It just seems confusing to have different defaults for auto_explain and EXPLAIN. I'd even vote for making that change still for PG18, since this feels like an oversight that the defaults were not kept aligned.
log_min_duration = 0, log_buffers = off: 11231 tps log_min_duration = 0, log_buffers = on: 11106 tps log_min_duration = -1 (off): 13297 tps So it is possible to measure it, at least.
Seems small enough not to worry about it.