Re: Default gucs for EXPLAIN

Поиск
Список
Период
Сортировка
От Nikolay Samokhvalov
Тема Re: Default gucs for EXPLAIN
Дата
Msg-id kajy60kk.acfabec7-c3a7-4d21-a867-c63f93635a47@we.are.superhuman.com
обсуждение исходный текст
Ответ на Default gucs for EXPLAIN  (Vik Fearing <vik@postgresfriends.org>)
Ответы Re: Default gucs for EXPLAIN  (Bruce Momjian <bruce@momjian.us>)
Список 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 по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Inlining of couple of functions in pl_exec.c improves performance
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: Collation versioning