Re: Default gucs for EXPLAIN

Le mer. 3 juin 2020 à 04:16, David Fetter <david(at)fetter(dot)org> a écrit :

> On Tue, Jun 02, 2020 at 09:28:48PM +0200, Vik Fearing wrote:
> > On 6/2/20 7:54 PM, David G. Johnston wrote:
> > > At this point, given the original goal of the patch was to try and
> > > grease a smoother path to changing the default for BUFFERS, and
> > > that people seem OK with doing just that without having this
> > > patch, I'd say we should just change the default and forget this
> > > patch. There hasn't been any other demand from our users for this
> > > capability and I also doubt that having BUFFERS on by default is
> > > going to bother people.
> >
> > What about WAL? Can we turn that one one by default, too?
> >
> > I often find having VERBOSE on helps when people don't qualify their
> > columns and I don't know the schema. We should turn that on by
> > default, as well.
>
> +1 for all on (except ANALYZE because it would be a foot cannon) by
> default. For those few to whom it really matters, there'd be OFF
> switches.
>
>
+1 for all on, except ANALYZE (foot cannon as David says) and VERBOSE
(verbose is something you ask for when the usual display isn't enough).

-1 for GUCs, we already have too many of them.

--
Guillaume.