Re: hash-join forgets tuples - Mailing list pgsql-general

From Sebastian Freundt
Subject Re: hash-join forgets tuples
Date
Msg-id nhty873pauo.fsf@mack.math.tu-berlin.de
Whole thread Raw
In response to Re: hash-join forgets tuples  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane <tgl@sss.pgh.pa.us> writes:

> Sebastian Freundt <hroptatyr@gna.org> 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
>
>     * src/backend/nodes/tidbitmap.c: Fix logic error in tbm_intersect:
>     the intersection of a normal page and a lossy page has to be lossy,
>     because we don't know exactly which tuples on the page should
>     remain part of the bitmap.  Per Jie Zhang.

Ah, good hint. Indeed it is 8.1-devel. Let me examine your proposal.
Thanks Tom!

Regards,
Sebastian


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Optimizing query
Next
From: Aly Dharshi
Date:
Subject: Postgresql Books: Which one ?