Paul Wehr <sf_psql_general(at)informationsoftworks(dot)com> writes:
> A last try on this question. In the absence of any response, I'll assume
> the postgresql query optimizer simply doesn't take foreign keys into
> account in this way.
It does not, and never has, and yes there's a TODO item about that.
regards, tom lane