Teodor Sigaev <teodor@sigaev.ru> writes:
>> I found something strange with merge join. Let there are two table
> Sorry, postgresql's version is 8.4 from today CVS
Can't reproduce it here, either in HEAD or 8.4. Sure you have a clean
build with no local modifications? The outright-incorrect last plan
you show seems to indicate something rather badly wrong with pathkey
matching.
regards, tom lane