What We’re Excited About PostgreSQL 17

The upcoming release of PostgreSQL 17 is generating excitement due to its focus on enhancing performance, scalability, security, and compatibility while introducing new features to meet evolving user needs. Notable changes in version 17 include the decision to drop support for AIX and the transition from Autotools to Meson build system. Some of the most exciting commits include pg_createsubscriber, support for MERGE PARTITIONS and SPLIT PARTITIONS, incremental file system backup, enabling the failover of logical replication slots, and allowing EXPLAIN to report optimizer memory usage. Timescale has contributed 90 commits (3.5 percent) during the PostgreSQL 17 cycle, including the SLRU move to 64-bit indexes, refactoring for transitive comparisons, and introducing standard_ExplainOneQuery.