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

From Nikolay Samokhvalov
Subject Re: Default gucs for EXPLAIN
Date
Msg-id kajy60kk.acfabec7-c3a7-4d21-a867-c63f93635a47@we.are.superhuman.com
Whole thread Raw
In response to Default gucs for EXPLAIN  (Vik Fearing <vik@postgresfriends.org>)
Responses Re: Default gucs for EXPLAIN
List pgsql-hackers
This is a very good improvement! Using information about buffers is my favorite way to optimize queries.

Not having BUFFERS enabled by default means that in most cases, when asking for help, people send execution plans without buffers info.

And it's simply in on event to type "(ANALYZE, BUFFERS)" all the time.

So I strongly support this change, thank you, Vik.

On Sat, May 23 2020 at 02:14, Vik Fearing <vik@postgresfriends.org> wrote:

Here is a patch to provide default gucs for EXPLAIN options.

I have two goals with this patch. The first is that I personally
*always* want BUFFERS turned on, so this would allow me to do it without typing it every time.

The second is it would make it easier to change the actual default for settings if we choose to do so because users would be able to switch it back if they prefer.

The patch is based off of a995b371ae.
--
Vik Fearing

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Inlining of couple of functions in pl_exec.c improves performance
Next
From: Julien Rouhaud
Date:
Subject: Re: Collation versioning