PostgreSQL 18 now supports virtual generated columns, indexable expressions without burning storage. Perfect for standardizing queries in analytics-heavy pipelines.
Pair that with planner constraint exclusion (constraint_exclusion=on), and Postgres can dodge irrelevant table scans based on constraints. Less IO. Faster ad-hoc BI queries.
