Horton

Re: BUG #15857: Parallel Hash Join makes join instead of exists

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: krujkov@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Date: 2019-06-18T13:17:02Z
Lists: pgsql-bugs 
Thomas Munro <thomas.munro@gmail.com> writes:
> Here's a tidier version with a comment and commit message.

It seems a little weird to make the join-type test be the first one
in the if() condition: it doesn't seem like the most important thing
to test, and it doesn't agree with the way you've worded the comment.
Otherwise +1.

			regards, tom lane

Commits

  1. Prevent Parallel Hash Join for JOIN_UNIQUE_INNER.