undefined | Better HN

0 pointstaspeotis3y ago0 comments

I would try running that fiddle on something more recent than Postgres 9.6

0 comments

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.

taspeotisOP3y ago

I have done my own (simple) testing on Postgres 13 and was unable to make Postgres elide the join.

j / k navigate · click thread line to collapse

0 pointstaspeotis3y ago0 comments

I would try running that fiddle on something more recent than Postgres 9.6

0 comments

mdavidn3y 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.

taspeotisOP3y ago

I have done my own (simple) testing on Postgres 13 and was unable to make Postgres elide the join.

j / k navigate · click thread line to collapse