Re: Default gucs for EXPLAIN - Mailing list pgsql-hackers

From David Rowley
Subject Re: Default gucs for EXPLAIN
Date
Msg-id CAApHDvoxcovmhfqQ8EcMbKqSfpUDDjvEu-VG4=GRigOzwwry=A@mail.gmail.com
Whole thread Raw
In response to Re: Default gucs for EXPLAIN  (Vik Fearing <vik@postgresfriends.org>)
Responses Re: Default gucs for EXPLAIN
List pgsql-hackers
On Tue, 26 May 2020 at 23:59, Vik Fearing <vik@postgresfriends.org> wrote:
> Are you saying we should have all new EXPLAIN options off forever into
> the future because apps won't know about the new data?  I guess we
> should also not ever introduce new plan nodes because those won't be
> known either.

Another argument against this is that it creates dependency among the
new GUCs. Many of the options are not compatible with each other. e.g.

postgres=# explain (timing on) select 1;
ERROR:  EXPLAIN option TIMING requires ANALYZE

Would you propose we just error out in that case, or should we
silently enable the required option, or disable the conflicting
option?

David



pgsql-hackers by date:

Previous
From: Masahiro Ikeda
Date:
Subject: Re: Why don't you to document pg_shmem_allocations view's name list?
Next
From: "David G. Johnston"
Date:
Subject: Re: Default gucs for EXPLAIN