PostgreSQL views and materialized views and how they influenced TimescaleDB

Re:PostgreSQL views and materialized views and how they infl... by taspeotis on Thursday July 14, 2022 @09:25PM (#32103540)

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

[ Parent | on HN ]

Re:PostgreSQL views and materialized views and how they infl... by mdavidn on Friday July 15, 2022 @12:11AM (#32104530)

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.

[ Parent | on HN ]

Re:PostgreSQL views and materialized views and how they infl... by taspeotis on Friday July 15, 2022 @01:18AM (#32104851)

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

[ Parent | on HN ]