`tsvector`, `tsquery` for searching document content - **JSON columns** — store and query JSON data natively - **Window functions** — `ROW_NUMBER()`, `RANK()`, `LAG()`, `LEAD()` for analytical queries - **ENUM types** — restrict a column to a fixed set of values at the database level - **Concurrent