From: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | krujkov(at)gmail(dot)com, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: BUG #15857: Parallel Hash Join makes join instead of exists |
Date: | 2019-06-18 14:38:41 |
Message-ID: | CA+hUKG+7CONVt6GSvFv0ixOgJaC=OvUGy05=cDpeSFE14qakYA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Wed, Jun 19, 2019 at 2:05 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> OK to push as far as I'm concerned. I am not expecting to have to
> re-wrap given the lack of packagers complaints so far, and if we
> do re-wrap, I'd be OK with including this fix.
Done.
Vladimir, thanks for the report! Unfortunately the fix is not
included in the out-of-schedule 11.4 release that's about to be made
(unless something triggers a re-wrap), but you should expect it in the
next regular release[1]. In the meantime you might be able to work
around the problem by using a different but equivalent join condition
so you get a semi-join, or by turning off enable_parallel_hash. Even
with the fix you'll probably get better performance if you can
convince it to use a semi-join.
[1] https://www.postgresql.org/developer/roadmap/
--
Thomas Munro
https://enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Jorge Gustavo Rocha | 2019-06-18 14:43:10 | Re: BUG #15827: Unable to connect on Windows using pg_services.conf using Python psycopg2 |
Previous Message | Tom Lane | 2019-06-18 14:05:58 | Re: BUG #15857: Parallel Hash Join makes join instead of exists |