4 ms·
Postgres can do it, you're correct, but in my experience it rarely happens with any view that's even slightly non-trivial even on recent versions of Postgres. M
by firloop 4y ago
Postgres can do it, you're correct, but in my experience it rarely happens with any view that's even slightly non-trivial even on recent versions of Postgres. Most views with a join break predicate pushdown. It greatly reduces the usecases of views in practice.
- sarchertech 4y agoI haven’t had any problems with this at all and I’ve been using joins in my views for years. Are you using CTEs in your views?
- deleted 4y ago[deleted]
- tomnipotent 4y agoPostgres 12 fixed the CTE issue.
- bavell 4y agoPostgres docs on CTEs: https://www.postgresql.org/docs/current/queries-with.html https://www.postgresql.org/docs/current/queries-with.html