RE: [Bugg hash join and parallel worker]

Hello,
I can't reproduce the scenario, because we don't have the current minor release (13.14).

Best Regards

-----Message d'origine-----
De : Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Envoyé : mercredi 28 février 2024 17:30
À : GADACHA Rachid (Acoss) <rachid(dot)gadacha(at)acoss(dot)fr>
Cc : pgsql-bugs(at)lists(dot)postgresql(dot)org
Objet : Re: [Bugg hash join and parallel worker]

"GADACHA Rachid (Acoss)" <rachid(dot)gadacha(at)acoss(dot)fr> writes:
> We encounter an error when we join 2 subqueries with large tables like below.
> ...
> Version postgresql : PostgreSQL 13.2 on x86_64-koji-linux-gnu,
> compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit

13.2 is extremely old. Can you reproduce this on the current minor release (13.14)?

regards, tom lane