Re: BUMP: Using foreign key constraint to eliminate unnecessary joins in view

Paul Wehr <sf_psql_general@informationsoftworks.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