On: Soft deletion probably isn't worth it

[firloop]

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 → firloop]

I 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?

[bavell → sarchertech]

Postgres docs on CTEs: https://www.postgresql.org/docs/current/queries-with.html

[tomnipotent → sarchertech]

Postgres 12 fixed the CTE issue.