| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | David Raymond <David(dot)Raymond(at)tomtom(dot)com> |
| Cc: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #15922: Simple select with multiple exists filters returns duplicates from a primary key field |
| Date: | 2019-07-24 17:06:38 |
| Message-ID: | 30486.1563987998@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
David Raymond <David(dot)Raymond(at)tomtom(dot)com> writes:
> The cost tweaks let me slash the size right down to where the dump is 150 kB, which I've attached. Don't know if the mailing list will strip it, but you're also directly in the To: list.
Thanks for the test case!
However ... I fail to reproduce any problem on HEAD or v11 branch tip.
After perusing the commit log, I believe the reason why not is this
post-11.4 bug fix:
https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=14d8b539d
which I'd forgotten about, but it seems to match your problem exactly.
That makes this a duplicate of bug #15857.
Don't know if you're in a position to build from source, but if so,
that's just about a one-line fix. Otherwise, it looks like turning
off enable_parallel_hash would be the minimal workaround until 11.5
comes out next month.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2019-07-24 18:02:23 | Re: Attribute has wrong type in ALTER TABLE |
| Previous Message | Christopher Browne | 2019-07-24 16:08:12 | Re: Request for resolution || Support |