| From: | "Jelte Fennema-Nio" <postgres(at)jeltef(dot)nl> |
|---|---|
| To: | "David Rowley" <dgrowleyml(at)gmail(dot)com>, "Fujii Masao" <masao(dot)fujii(at)oss(dot)nttdata(dot)com> |
| Cc: | "Michael Christofides" <michael(at)pgmustard(dot)com>, "Guillaume Lelarge" <guillaume(at)lelarge(dot)info>, "Greg Sabino Mullane" <htamfids(at)gmail(dot)com>, "Robert Haas" <robertmhaas(at)gmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "Nikolay Samokhvalov" <samokhvalov(at)gmail(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE |
| Date: | 2025-05-30 12:43:14 |
| Message-ID: | DA9I5MGB2LO5.2BHSEGIAT74Y7@jeltef.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrey Borodin | 2025-05-30 12:55:44 | Re: Persist injection points across server restarts |
| Previous Message | Jelte Fennema-Nio | 2025-05-30 12:33:27 | Reduce DEBUG level of catcache refreshing messages |