#Postgres Pro

Recent posts

January 12   •   PostgreSQL
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 process statistics pg_stats: statistics for range type columns Planner: exclusion of unnecessary table self-joins Planner: materialized CTE statistics Planner: accessing a table with multiple clauses Index range scan optimization dblink, postgres_fdw: detailed wait events Logical replication: migration of replication slots during publisher upgrade Replication slot use log Unicode: new information functions New function: xmltext AT LOCAL support Infinite intervals ALTER SYSTEM with unrecognized custom parameters Building the server from source