Cilantro Loves Linux

Sep 26, 2025 · Databases

PostgreSQL 18 Released: 5 Key Innovations for Performance, Upgrades & Developer Productivity

PostgreSQL 18 introduces major improvements including asynchronous I/O for up to 3x scan performance, pg_upgrade preserving statistics and --swap for minute-level upgrades, virtual generated columns, UUIDv7, temporal constraints, enhanced observability, OAuth 2.0 authentication, and parallel logical replication, reducing operational overhead and boosting developer productivity.