Tom Lane <[EMAIL PROTECTED]> writes:
> Sebastian Freundt <[EMAIL PROTECTED]> writes:
>> using a highly surjective left (or inner) join to a table reveals data
>> loss if the hash join method is used.
>
> In which PG version? Given that you appear to be playing w
Hello,
using a highly surjective left (or inner) join to a table reveals data
loss if the hash join method is used.
Here, highly surjective means I have a table with about 1.4 million tuples
which map to a table with about 4 tuples.
Now here's the explanation:
qaos=# explain select anfs.an
