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
The November commitfest is ripe with new interesting features! Without further ado, let’s proceed with the review. If you missed our July and September commitfest reviews, you can check them out here: 2023-07 , 2023-09 . ON LOGIN trigger Event triggers for REINDEX ALTER OPERATOR: commutator, negator, hashes, merges pg_dump --filter=dump.txt psql: displaying default privileges pg_stat_statements: track statement entry timestamps and reset min/max statistics pg_stat_checkpointer: checkpointer...| 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