Re: Default gucs for EXPLAIN

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