I just noticed a little optimizer problem - in second query there is unused 'tycho t2' table alias which gets backend buried.
It's not an "unused table alias", it is specifying the cartesian product of `tycho' with itself. I don't see how this is an optimizer problem: it's a perfectly legitimate query, albeit one that is unlikely to execute very quickly.
-Neil
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster