Postgres Pro
Downloads
Home   >   mailing lists

Re: Merge join and index scan strangeness - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Merge join and index scan strangeness
Date
Msg-id 2177.1266589188@sss.pgh.pa.us
Whole thread Raw
In response to Re: Merge join and index scan strangeness  (Teodor Sigaev <teodor@sigaev.ru>)
Responses Re: Merge join and index scan strangeness
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: Avoiding bad prepared-statement plans.
Next
From: Teodor Sigaev
Date:
Subject: Fwd: Re: Merge join and index scan strangeness