Re: BUFFERS enabled by default in EXPLAIN (ANALYZE)

From: Vik Fearing <vik(at)postgresfriends(dot)org>
To: Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: BUFFERS enabled by default in EXPLAIN (ANALYZE)
Date: 2021-11-13 01:34:05
Message-ID: c124a522-9532-8522-b730-059db9147ae3@postgresfriends.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 11/12/21 11:58 PM, Nikolay Samokhvalov wrote:
> Re-reading the thread [1] (cannot answer there – don't have those emails in
> my box anymore), I see that there was strong support for enabling BUFFERS
> in EXPLAIN ANALYZE by default. And there were patches. Commitfest entry [2]
> was marked Rejected because there were questions to the implementation
> based on GUCs.
>
> Attached is a simple patch enabling BUFFERS by default, without involving
> GUCs.

I obviously agree with this (although I still wish we had gucs as we
keep adding more and more options to EXPLAIN).

The patch looks good to me, too.

+1
--
Vik Fearing

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Zhihong Yu 2021-11-13 01:40:57 Re: support for MERGE
Previous Message Robert Haas 2021-11-13 00:33:55 Re: ALTER TABLE DETACH PARTITION violates serializability