Re: BUG #15857: Parallel Hash Join makes join instead of exists - Mailing list pgsql-bugs

From Thomas Munro
Subject Re: BUG #15857: Parallel Hash Join makes join instead of exists
Date
Msg-id CA+hUKGKcPcayiknzwx5BAo41cs-ymtLk6b8Ebg7fjXsVMvmcUQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #15857: Parallel Hash Join makes join instead of exists  (Thomas Munro <thomas.munro@gmail.com>)
Responses Re: BUG #15857: Parallel Hash Join makes join instead of exists
List pgsql-bugs
On Tue, Jun 18, 2019 at 9:24 PM Thomas Munro <thomas.munro@gmail.com> wrote:
> That points to the problem: for JOIN_UNIQUE_INNER we plan a Parallel
> Hash Join, but that's nonsense, there is no code to unique-ify the
> partial inner side (because that's not possible).   There may be
> something better we can do here (like understanding that this should
> really be a semi-join), but this works for me to prevent the bad plan:

Here's a tidier version with a comment and commit message.

-- 
Thomas Munro
https://enterprisedb.com

Attachment

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15858: could not stat file - over 4GB
Next
From: Joao Ferreira
Date:
Subject: Querying foreign table with SP-GiST index results in “ERROR: cache lookup failed for type 0”