Klint Gore <kg@kgb.une.edu.au> writes:
> There are 55k rows in t1 (103 fields) and 10k in t2 (4 fields, 4 is text).
> before vacuum analyze the query gave 10k rows like it was doing an inner
> join. after vacuum analyze gave the full 55k.
Sounds like a bug ...
> 7.4.0, rh linux 7.2, p4 (non ht) cpu.
You are of course aware that there are a lot of known bugs in 7.4.0?
Please try it on 7.4.2.
If you can still make it happen on 7.4.2 then I'd be interested in a
test case...
regards, tom lane