David Raymond <David.Raymond@tomtom.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
mailinglist 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