A new software update is available: PostgreSQL 17 Beta 1 released
PostgreSQL 17 Beta 1 released
PostgreSQL 17 Beta 1 has been released. The update offers enhancements to query and operational performance, such as a 20x memory reduction in vacuum, a stream I/O interface, and configurable parameters for transaction, subtransaction, and multixact buffer scalability. It also optimizes queries utilizing planner statistics and the sort order of frequent table expressions (WITH queries), speeds up query execution with the IN clause and a B-tree index, eliminates superfluous IS NOT NULL statements, and supports concurrent index construction for BRIN indexes.
