"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