3 ms·
IIRC Postgres has supported predicate push down on trivial views like this for over a decade now, and possibly even more complex views these days (I haven't kep
by dafelst 4y ago
IIRC Postgres has supported predicate push down on trivial views like this for over a decade now, and possibly even more complex views these days (I haven't kept up with the latest greatest changes).
- firloop 4y agoPostgres 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