Horton

Re: [PERFORM] Hash Anti Join performance degradation

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Cédric Villemain <cedric.villemain.debian@gmail.com>, panam <panam@gmx.net>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-06-01T20:47:36Z
Lists: pgsql-hackers, pgsql-performance 
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