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

From Robert Haas
Subject Re: Default gucs for EXPLAIN
Date
Msg-id CA+TgmoYH_p-y=45SAJ58cU6jsMH6ojgqQZiA2aePpvZ0J+uLbA@mail.gmail.com
Whole thread Raw
In response to Re: Default gucs for EXPLAIN  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-hackers
On Tue, May 26, 2020 at 7:30 AM David Rowley <dgrowleyml@gmail.com> wrote:
> I'm against adding GUCs to control what EXPLAIN does by default.
>
> A few current GUCs come to mind which gives external control to a
> command's behaviour are:
>
> standard_conforming_strings
> backslash_quote
> bytea_output
>
> It's pretty difficult for application authors to write code that will
> just work due to these GUCs. We end up with GUCs like
> escape_string_warning to try and help application authors find areas
> which may be problematic.

I agree with this concern, as well as with what David says later,
namely that the concern is less here than in some other cases but
still not zero.

I do think the idea of changing the default for BUFFERS from OFF to ON
is a pretty good one, though.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Chapman Flack
Date:
Subject: Re: pie-in-sky idea: 'sensitive' function parameters
Next
From: Tom Lane
Date:
Subject: Re: pie-in-sky idea: 'sensitive' function parameters