Re: [PERFORM] Hash Anti Join performance degradation - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PERFORM] Hash Anti Join performance degradation
Date
Msg-id 24707.1306961256@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PERFORM] Hash Anti Join performance degradation  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [PERFORM] Hash Anti Join performance degradation
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> I guess the real issue here is that m1.id < m2.id has to be evaluated
> as a filter condition rather than a join qual.

Well, if you can invent an optimized join technique that works for
inequalities, go for it ... but I think you should get at least a
PhD thesis out of that.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [PERFORM] Hash Anti Join performance degradation
Next
From: Andrew Chernow
Date:
Subject: Re: PQdeleteTuple function in libpq