pgsql: Try again to fix the way the scanjoin_target is used with partia

Поиск
Список
Период
Сортировка
От Robert Haas
Тема pgsql: Try again to fix the way the scanjoin_target is used with partia
Дата
Msg-id E1bE0PD-0000l2-OE@gemulon.postgresql.org
обсуждение исходный текст
Ответы Re: pgsql: Try again to fix the way the scanjoin_target is used with partia  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-committers
Try again to fix the way the scanjoin_target is used with partial paths.

Commit 04ae11f62e643e07c411c4935ea6af46cb112aa9 removed some broken
code to apply the scan/join target to partial paths, but its theory
that this processing step is totally unnecessary turns out to be wrong.
Put similar code back again, but this time, check for parallel-safety
and avoid in-place modifications to paths that may already have been
used as part of some other path.

(This is not an entirely elegant solution to this problem; it might
be better, for example, to postpone generate_gather_paths for the
topmost scan/join rel until after the scan/join target has been
applied.  But this is not the time for such redesign work.)

Amit Kapila and Robert Haas

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/54f5c5150fa05d7ad15f8406debd5a2b394885b5

Modified Files
--------------
src/backend/optimizer/plan/planagg.c          |  3 +-
src/backend/optimizer/plan/planner.c          | 81 ++++++++++++++++++++++++++-
src/backend/optimizer/prep/prepunion.c        |  6 +-
src/backend/optimizer/util/pathnode.c         |  7 ++-
src/include/optimizer/pathnode.h              |  3 +-
src/test/regress/expected/select_parallel.out | 32 +++++++++++
src/test/regress/sql/select_parallel.sql      | 11 ++++
7 files changed, 133 insertions(+), 10 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: pgsql: Add VACUUM (DISABLE_PAGE_SKIPPING) for emergencies.
Следующее
От: Robert Haas
Дата:
Сообщение: pgsql: pg_visibility: Add pg_truncate_visibility_map function.