pgsql: Prevent Parallel Hash Join for JOIN_UNIQUE_INNER.

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема pgsql: Prevent Parallel Hash Join for JOIN_UNIQUE_INNER.
Дата
Msg-id E1hdEya-0008P7-Bg@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Prevent Parallel Hash Join for JOIN_UNIQUE_INNER.

WHERE EXISTS (...) queries cannot be executed by Parallel Hash Join
with jointype JOIN_UNIQUE_INNER, because there is no way to make a
partial plan totally unique.  The consequence of allowing such plans
was duplicate results from some EXISTS queries.

Back-patch to 11.  Bug #15857.

Author: Thomas Munro
Reviewed-by: Tom Lane
Reported-by: Vladimir Kriukov
Discussion: https://postgr.es/m/15857-d1ba2a64bce0795e%40postgresql.org

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/14d8b539d3bd4cf9faf65ca86a733bada202107f

Modified Files
--------------
src/backend/optimizer/path/joinpath.c | 7 +++++--
1 file changed, 5 insertions(+), 2 deletions(-)


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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: pgsql: Prevent Parallel Hash Join for JOIN_UNIQUE_INNER.
Следующее
От: noreply@postgresql.org
Дата:
Сообщение: pgsql: Tag refs/tags/REL9_6_14 was created