4 ms·
I ran into this recently on a newer version. Postgres will not use the presence of a foreign key (referencing a unique index) to skip unnecessary inner joins.
by mdavidn 4y ago
I ran into this recently on a newer version. Postgres will not use the presence of a foreign key (referencing a unique index) to skip unnecessary inner joins.
- taspeotis 4y agoI have done my own (simple) testing on Postgres 13 and was unable to make Postgres elide the join.