Re: BUMP: Using foreign key constraint to eliminate unnecessary joins in view - Mailing list pgsql-general

From Tom Lane
Subject Re: BUMP: Using foreign key constraint to eliminate unnecessary joins in view
Date
Msg-id 24138.1239663514@sss.pgh.pa.us
Whole thread Raw
In response to BUMP: Using foreign key constraint to eliminate unnecessary joins in view  (Paul Wehr <sf_psql_general@informationsoftworks.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: BUMP: Using foreign key constraint to eliminate unnecessary joins in view
Next
From: NTPT
Date:
Subject: Re: In memory Database for postgres