#SQL

PostgreSQL 17 was released on September 26, 2024, adding the SQL/JSON JSON_TABLE command, a new vacuum memory structure that uses up to 20x less memory, higher WAL write throughput, and logical-replication improvements for upgrades and high availability. Here is what changed.

PostgreSQL 16 was released on September 14, 2023, improving query parallelism and bulk loading with COPY, enabling logical replication from standby servers, adding SIMD acceleration, and introducing the pg_stat_io view for granular I/O monitoring. Here is what changed.

PostgreSQL 15 was released on October 13, 2022, adding the SQL-standard MERGE command, improving in-memory and on-disk sort performance by 25 to 400%, adding LZ4 and Zstandard WAL compression, and introducing a jsonlog logging format. Here is what changed.