Bill Moseley <moseley(at)hank(dot)org> writes:
> The first plan below returns the correct number of rows, the second plan does
> not. These are after I did the reindex, btw.
Bizarre. What are the datatypes of the columns being joined on? If
they're string types, what's your database locale and encoding?
regards, tom lane