Re: New EXPLAIN option: ALL

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: New EXPLAIN option: ALL
Дата
в 13:32:31
Msg-id
30903.1557927151@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
New EXPLAIN option: ALL David Fetter <david@fetter.org>
Re: New EXPLAIN option: ALL David Fetter <david@fetter.org>
Re: New EXPLAIN option: ALL Sergei Kornilov <sk@zsrv.org>
Re: New EXPLAIN option: ALL David Fetter <david@fetter.org>
Re: New EXPLAIN option: ALL Andres Freund <andres@anarazel.de>
Re: New EXPLAIN option: ALL David Fetter <david@fetter.org>
Re: New EXPLAIN option: ALL Andres Freund <andres@anarazel.de>
Re: New EXPLAIN option: ALL David Fetter <david@fetter.org>
Re: New EXPLAIN option: ALL Andres Freund <andres@anarazel.de>
Re: New EXPLAIN option: ALL Tom Lane <tgl@sss.pgh.pa.us>
Re: New EXPLAIN option: ALL Stephen Frost <sfrost@snowman.net>
Re: New EXPLAIN option: ALL David Fetter <david@fetter.org>
Re: New EXPLAIN option: ALL Stephen Frost <sfrost@snowman.net>
Re: New EXPLAIN option: ALL Tom Lane <tgl@sss.pgh.pa.us>
Re: New EXPLAIN option: ALL Stephen Frost <sfrost@snowman.net>
Re: New EXPLAIN option: ALL David Fetter <david@fetter.org>
Re: New EXPLAIN option: ALL David Fetter <david@fetter.org>
Re: New EXPLAIN option: ALL Tom Lane <tgl@sss.pgh.pa.us>
Re: New EXPLAIN option: ALL David Fetter <david@fetter.org>
Re: New EXPLAIN option: ALL Andres Freund <andres@anarazel.de>
Re: New EXPLAIN option: ALL Tom Lane <tgl@sss.pgh.pa.us>
Re: New EXPLAIN option: ALL Michael Paquier <michael@paquier.xyz>
Re: New EXPLAIN option: ALL David Fetter <david@fetter.org>
Re: New EXPLAIN option: ALL Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: New EXPLAIN option: ALL David Fetter <david@fetter.org>
Re: New EXPLAIN option: ALL Alvaro Herrera <alvherre@2ndquadrant.com>
Re: New EXPLAIN option: ALL Andres Freund <andres@anarazel.de>
Re: New EXPLAIN option: ALL Alvaro Herrera <alvherre@2ndquadrant.com>
Re: New EXPLAIN option: ALL Tom Lane <tgl@sss.pgh.pa.us>
Re: New EXPLAIN option: ALL Andres Freund <andres@anarazel.de>
Re: New EXPLAIN option: ALL Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: New EXPLAIN option: ALL David Fetter <david@fetter.org>
Re: New EXPLAIN option: ALL Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: New EXPLAIN option: ALL Daniel Gustafsson <daniel@yesql.se>
Re: New EXPLAIN option: ALL David Fetter <david@fetter.org>
Re: New EXPLAIN option: ALL Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: New EXPLAIN option: ALL Robert Haas <robertmhaas@gmail.com>
Re: New EXPLAIN option: ALL David Fetter <david@fetter.org>
Re: New EXPLAIN option: ALL Tom Lane <tgl@sss.pgh.pa.us>
Re: New EXPLAIN option: ALL Andres Freund <andres@anarazel.de>
Re: New EXPLAIN option: ALL Tom Lane <tgl@sss.pgh.pa.us>
Re: New EXPLAIN option: ALL Robert Haas <robertmhaas@gmail.com>
Re: New EXPLAIN option: ALL Robert Haas <robertmhaas@gmail.com>
Re: New EXPLAIN option: ALL Rafia Sabih <rafia.pghackers@gmail.com>
Re: New EXPLAIN option: ALL David Fetter <david@fetter.org>
Re: New EXPLAIN option: ALL Robert Haas <robertmhaas@gmail.com>
Re: New EXPLAIN option: ALL Peter Geoghegan <pg@bowt.ie>
Re: New EXPLAIN option: ALL Vik Fearing <vik.fearing@2ndquadrant.com>
Re: New EXPLAIN option: ALL "Nasby, Jim" <nasbyj@amazon.com>
David Fetter  writes:
> I hope the patch is a little easier to digest as now attached.

To be blunt, I find 500K worth of changes in the regression test
outputs to be absolutely unacceptable, especially when said changes
are basically worthless from a diagnostic standpoint.  There are
at least two reasons why this won't fly:

* Such a change would be a serious obstacle to back-patching
regression test cases that involve explain output.

* Some buildfarm members use nonstandard settings (notably
force_parallel_mode, but I don't think that's the only one).
We are *not* going to maintain variant output files to try to cope
with all those combinations.  It'd be even more disastrous for
private forks that might have their own affected settings.

I don't know how to make progress towards the original goal
without having a regression-test disaster, but what we have
here is one.

			regards, tom lane


В списке pgsql-hackers по дате отправления
От: Kuntal Ghosh
Дата:
От: David Fetter
Дата:
Сообщение: Re: New EXPLAIN option: ALL
FAQ