Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE

Поиск
Список
Период
Сортировка
От Jelte Fennema-Nio
Тема Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE
Дата
Msg-id DA9I5MGB2LO5.2BHSEGIAT74Y7@jeltef.nl
обсуждение исходный текст
Ответ на Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE  (Nikolay Samokhvalov <samokhvalov@gmail.com>)
Список pgsql-hackers
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.



В списке pgsql-hackers по дате отправления: