Spring is in full swing as we bring you the hottest winter news of the January Commitfest. Let’s get to the good stuff right away! Previous articles about PostgreSQL 17: 2023-07 , 2023-09 , 2023-11 . Incremental backup Logical replication: maintaining the subscription status when upgrading the subscriber server Dynamic shared memory registry EXPLAIN (memory): report memory usage for planning pg_stat_checkpointer: restartpoint monitoring on replicas Building BRIN indexes in parallel mode Que...| postgrespro.com
We continue to follow the news of the PostgreSQL 17 development. Let’s find out what the September commitfest brings to the table. If you missed our July commitfest review, you can check it out here: 2023-07 . Removed the parameter old_snapshot_threshold New parameter event_triggers New functions to_bin and to_oct New system view pg_wait_events EXPLAIN: a JIT compilation time counter for tuple deforming Planner: better estimate of the initial cost of the WindowAgg node pg_constraint: NOT NU...| postgrespro.com
We continue to follow the news in the world of PostgreSQL. The PostgreSQL 16 Release Candidate 1 was rolled out on August 31. If all is well, PostgreSQL 16 will officially release on September 14. What has changed in the upcoming release after the April code freeze? What’s getting into PostgreSQL 17 after the first commitfest? Read our latest review to find out! PostgreSQL 16 For reference, here are our previous reviews of PostgreSQL 16 commitfests: 2022-07 , 2022-09 , 2022-11 , 2023-01 ,...| postgrespro.com