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

On Mon, Apr 13, 2009 at 2:36 PM, Paul Wehr
<sf_psql_general@informationsoftworks.com> wrote:
>
> I am looking for a way to get the plan to show only a seq scan of test2,
> since test1 does not contribute any columns, and we know from the
> not-deferrable-not-null-primary-key that there will always be exactly one
> match.
>
> Am I just missing something obvious, or does postgresql (currently) not do
> that?
>

postgres will look at all tables involved, i think there is work to
make it smart enough to make what you describe but that's in the
future...


--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157