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 with 8.1devel
> code, you might be
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 with 8.1devel
code, you might be needing this bug fix:
2005-07-23 22:25 tgl
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
