Benjamin Smith <lists(at)benjamindsmith(dot)com> writes:
> And, this dropped the query time from between 2.2-30 seconds all the
> way down to just 55-ish ms, without any new indexes! What's more, the
> improvement came from a move of a block I thought more or less
> unimportant!
> // tries to put jaw back into mouth //
Yeah ... we really need to fix the planner so it can do this for you,
as it does with regular inner joins ...
regards, tom lane