Extended Statistics in PG19: Virtual Columns, pg_restore_extended_stats(), pg_clear_extended_stats() and pg_dump
Introduction: Have you ever wondered why an Optimized PostgreSQL query suddenly becomes slow, and why the query planner chose a
PG19 Hacktober: 31 Days of New Features: Smarter Planner, Fewer Rows: Anti Joins, Memoize, Aggregate Pushdown and Expression Simplification
PostgreSQL 19’s optimizer work targets two limits: rewrites the planner couldn’t prove safe, and plans it couldn’t see. NULL semantics
PG19 Hacktober: 31 Days of New Features: WAIT FOR: Read-Your-Writes on PostgreSQL Standbys
Welcome to the 7th blog post of PG19 Hacktober!! In PostgreSQL 18 and earlier, asynchronous streaming replication introduced an unavoidable
Others, PG19 Hacktober
PG19 Hacktober: 31 Days of New Features: Watching VACUUM and ANALYZE: New Progress Columns, Logging and WAL Full-Page-Image Reporting
We’re just into the 5th day of PG19 Hacktober, and we continue to see how PostgreSQL 19 beta 4 improves
PG19 Hacktober: 31 Days of New Features: Decoding FETCH Size Grouping and Generic vs Custom Plans in pg_stat_statements
Welcome to the 4th blog post of PG19 Hacktober!! pg_stat_statements is one of the PostgreSQL’s primary tool for tracking query
PG19 Hacktober: 31 Days of New Features: Autovacuum Grows Up: Parallel Workers and the New Table-Priority Scoring System
Welcome to the Day3 of PG19 Hacktober!! If you’ve run PostgreSQL in production, you’ve probably watched autovacuum spend hours on
PG19 Hacktober: 31 Days of New Features : PostgreSQL I/O Performance Improvements: Smarter Read-Ahead & Visibility Map Updates
Welcome to the 2nd blog post of PG19 Hacktober! In two of our previous posts, we explored one of the most
PG19 Hacktober: 31 Days of New Features : A Tour of What’s New (and What Didn’t Make It) in PostgreSQL 19 Beta 4
Welcome to Day 1 of PG19 Hacktober, following last year’s PG18 Hacktober. Every day this October we’ll take a new