Interesting PostgreSQL Blog Articles

/ home / computer / postgresql / .

Table of Contents

General

• Elizabeth Christensen, Crunchy Data, 2024-03-28: Contributing to Postgres 101: A Beginner’s Experience
• Andreas ‘ads’ Scherbaum, 2024-06-14: PostgreSQL Development Conference 2024 - Review
• pgPedia
• Stefanie Janine Stölting, ProOpenSource OÜ, 2024-09-04: The Timescale PostgreSQL Survey 2024
• Hubert ‘depesz’ Lubaczewski, 2024-10-29: New way to search PostgreSQL documentation
• pgdoc ⚡ link
• Peter Eisentraut, EnterpriseDB, 2024-12-10: Where are all the PostgreSQL users?
• Andreas Scherbaum, PostgreSQL EU, 2025-02-17: Social Media Channels
• Peter Eisentraut, EnterpriseDB, 2025-06-24: Waiting for SQL:202y: Vectors
• Ben Dicken, PlanetScale, 2025-07-08: Caching
• Tom Kincaid, EnterpriseDB, 2025-08-18: PostgreSQL’s incredible trip to the top with developers
• Sarah Conway, Data Bene: 2025-09-08: Most Desired Database Three Years Running: PostgreSQL’s Developer Appeal
• Tom Kincaid, EnterpriseDB, 2025-10-19: Part 2: PostgreSQL’s incredible trip to the top with developers
• Tom Kincaid, EnterpriseDB, 2025-12-01: Part 3: Postgres Journey to the top with developers
• Jeremy Schneider, Ardent Performance Computing: PostgreSQL Links
• Kai Wagner, Percona, 2026-02-02: Hackorum - A Forum-Style View of pg-hackers
• Bruce Momjian, EnterpriseDB, 2026-01: What’s Missing in Postgres? and PDF
• Mark Callaghan, 2026-03-06: The first rule of database fight club: admit nothing
• Bruce Momjian, EnterpriseDB, 2026-03-11: The MySQL Shadow
• Vibhor Kumar, EnterpriseDB, 2026-03-11: Beyond Features: What a PostgreSQL Strategy Discussion Taught Me About Calm, Modern Platforms
• Jeffrey T. Pollock, Oracle Corp., 2026-02-11: Myth of the PostgreSQL Database Market – when does PostgreSQL-ish become PostgreSQL-not?
• Mark Wong, 2026-06-05: Acknowledged Individuals in the PostgreSQL Release Notes: 2026 Edition
• Joab Jackson, The Register, 2026-06-22: The database that refused to die: How Postgres survived its own creators - From academic toss-aside to cloud substrate
• Shaun Thomas, pgEdge, 2026-07-03: Looking Forward to Postgres 19: Checksums For All
• pgrust - A Postgres rewrite in Rust.
• Ahmed Darwich, Planetscale, 2026-07-23: What’s new in Postgres 19
• [https://nikolays.github.io/PGSimCity/](PostgreSQL SimCity)
• Dimitri Fontaine, Neon, 2026-07-28: SQL Improvements in PostgreSQL 11–18: A Personal Selection
• Joab Jackson, The Register, 2026-07-29: After rewriting SQLite in Rust, Turso turns its sights on Postgres - Cloud database upstart wants one virtual machine core to power multiple SQL frontends
• Shaun Thomas, pgEdge: 2026-07-31: Looking Forward to Postgres 19: The Cult of Functionality
• Lindsay Clark, The Register, 2026-08-19: Postgres pioneer credits Oracle with helping his database take over the world - Big Red’s acquisition of MySQL sent users running toward the open source alternative, says Michael Stonebraker
• Richard Yen, 2026-08-31: pg-catalog-almanac - Did you know: PG19 is on track to contain the most changes to pg_catalog in history
• Gülçin Yıldırım Jelínek, Clickhouse, 2026-09-01: New system views in PostgreSQL 19
• Dimitri Fontaine, Neon, 2026-09-03: Getting Ready for PostgreSQL 19
• Christophe Pettus, PGX, 2026-09-15: 19th Nervous Breakdown
• Elizabeth Garrett Christensen, Snowflake, 2026-09-16: What Is Happening with PostgreSQL 19?

Business

• Umair Shahid, Stormatics, 2025-01-15: Cut Cloud Costs with Smarter PostgreSQL CPU Core Allocation
• Hans-Jürgen Schönig, Cybertec, 2025-10-07: How it all began - 25 years of CYBERTEC
• Stefanie Janine Stölting, ProOpenSource OÜ, 2026-04-29: PostgreSQL Ecosystem Problems
• Christophe Pettus, PGX, 2026-04-28: Permissive by Choice, Permanent by Accident
• Jan Wieremjewicz, Percona, 2026-04-28: pgBackRest is archived, what now?

Internals

• boringSQL, PostgreSQL Storage Internals - How PostgreSQL stores, versions, and reclaims data: shared buffers, the 8KB page, MVCC, HOT updates, TOAST, and VACUUM.
• Jonathan Corbet, LWN.net, 2012-10-02: How 3.6 nearly broke PostgreSQL
• Jonathan Corbet, LWN.net, 2014-03-26: PostgreSQL pain points
• Ibrar Ahmed, Percona, 2019-10-17: Deep dive to PostgreSQL Indexes
• Laurenz Albe, Cybertec, 2020-04: PostgreSQL v13 new feature: tuning autovacuum on insert-only tables
• Stan Hu, Grzegorz Bizon, Gitlab, 2021-09-29: Why we spent the last month eliminating PostgreSQL subtransactions - How a mysterious stall in database queries uncovered a performance limitation with PostgreSQL.
• Craig Kerstiens, Crunchy Data, 2022-05-27: Postgres Databases and Schemas
• Andreas ‘ads’ Scherbaum, 2022-06-28: ctid and other PostgreSQL table internals
• Laurenz Albe, Cybertec, 2023-01: Transaction ID wraparound: a walk on the wild side
• Ants Aasma, Cybertec, 2023-06: Unexpected downsides of UUID keys in PostgreSQL
• Muhammad Ali, Stormatics, 2023-10-04: Vacuum in PostgreSQL
• Pierre Ducroquet, Pinaraf, 2024-03-18: Look ma, I wrote a new JIT compiler for PostgreSQL
• Semab Tariq, Stormatics, 2024-04-18: PostgreSQL Internals Part 3: Understanding Processes in PostgreSQL
• Semab Tariq, Stormatics, 2024-05-16: PostgreSQL Internals Part 1: Understanding database cluster, database and tables
• Semab Tariq, Stormatics, 2024-05-22: PostgreSQL Internals Part 2: Understanding Page Structure
• Muhammad Ali, Stormatics, 2024-05-09: Understanding PostgreSQL Fill Factor: Benefits, Drawbacks, and Best Practices
• Muhammad Ali, Stormatics, 2024-05-15: Removing bloat with pg_repack-extension
• Jake Edge, LWN.net, 2024-05-24: Atomic writes without tears
• Laurenz Albe, Cybertec, 2024-05-28: Why do I have a slow COMMIT in PostgreSQL?
• Gilles Darold (CTO), HexaCluster, 2024-06-10: PGTT Extension for Global Temporary Tables in PostgreSQL
• Shane Borden, 2024-06-18: Reduce Vacuum by Using “ON CONFLICT” Directive
• Andreas ‘ads’ Scherbaum, 2024-06-19: Understanding VACUUM, VACUUM template0, and Transaction ID Wraparound
• Laurenz Albe, Cybertec, 2024-06-24: Making the PostgreSQL visibility map visible
• Laurenz Albe, Cybertec, 2024-07: What you should know about Linux memory overcommit in PostgreSQL
• Daniel Vérité, 2024-07-01: Looking at the new built-in collation provider in PostgreSQL 17
• Abhishek Deb, Percona, 2024-07-01: How to Remove an Orphan Large Object in PostgreSQL With Vacuumlo
• Hubert ‘depesz’ Lubaczewski, 2024-07-19: What tables were touched within given range of wal LSN?
• Hans-Jürgen Schönig, Cybertec, 2024-08: Speeding up things with hint bits
• Umair Shahid, Stormatics, 2024-08-08: Locks in PostgreSQL – Concurrency Benefits and Performance Challenges
• Andrei Lepikhov, 2024-08-19: Postgres query re-optimisation in practice - on PostgreSQL built-in reoptimisation
• Semab Tariq, Stormatics, 2024-08-20: PostgreSQL Internals Part 4: A Beginner’s Guide to Understanding WAL in PostgreSQL
• Shane Borden, 2024-09-04: Follow-Up: Reduce Vacuum by Using “ON CONFLICT” Directive
• Pavel Stehule, 2024-09-06: How to get info about relations between system tables?
• Hans-Jürgen Schönig, Cybertec, 2024-09-10: Why “SELECT * FROM table” is NOT a read
• Tomas Vondra, EnterpriseDB, 2024-10-14: Tuning the glibc memory allocator (for Postgres)
• Stefanie Janine Stölting, ProOpenSource OÜ, 2024-10-16: Handling BLOBs In PostgreSQL
• Shiv Iyer, MinervaDB, 2024-10-18: Effective Methods for Tracking PostgreSQL Parameter Changes
• Semab Tariq, Stormatics, 2024-11-08: Scenarios That Trigger Autovacuum in PostgreSQL
• Radim Marek, boringSQL, 2024-11-23: DELETEs are difficult
• Gulcin Yildirim Jelinek, Xata, 2025-01-13: Anatomy of Table-Level Locks in PostgreSQL - This blog explains locking mechanisms in PostgreSQL, focusing on table-level locks that are required by Data Definition Language (DDL) operations.
• Jobin Augustine, Percona, 2025-01-14: What Hurts in PostgreSQL Part One: Temporary Tables
• Laurenz Albe, Cybertec, 2025-01-14: The power of open source in PostgreSQL
• Gulcin Yildirim Jelinek, Xata, 2025-01-20: Anatomy of table-level locks: Reducing locking impact - Not all operations require the same level of locking, and PostgreSQL offers tools and techniques to minimize locking impact.
• Peter Eisentraut, EnterpriseDB, 2025-01-21: Implementing thread-safe scanners and parsers in PostgreSQL
• Hubert ‘depesz’ Lubaczewski, 2025-02-19: Waiting for PostgreSQL 18 – Add delay time to VACUUM/ANALYZE (VERBOSE) and autovacuum logs
• Alexander Korotkov, OrioleDB, 2025-03-24: [https://www.orioledb.com/blog/better-table-access-methods](Why PostgreSQL needs a better API for alternative table engines?)
• Grant Fritchey, Redgate Software. 2025-04-02: Multi-Version Concurrency Control (MVCC) in PostgreSQL: Learning PostgreSQL with Grant
• Lukas Fittl, pganalyze, 2025-04-03: Postgres vs. SQL Server: B-Tree Index Differences & the Benefit of Deduplication
• Federico Campoli, 2025-04-07: Size matter
• Laurenz Albe, Cybertec, 2025-04-22: Type alignment and padding bytes: how to not waste space in PostgreSQL tables
• Andrei Lepikhov, 2025-04-22: On expressions’ reordering in Postgres
• Federico Campoli, 2025-04-29: The Tux and the Pachyderm
• Shayon Mukherjee, 2025-05-04: Another look into PostgreSQL CTE materialization and non-idempotent subqueries
• Sergey Solovev, 2025-05-03: How to handle files?
• Lukas Fittl, pganalyze, 2025-05-07: Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O
• Alexander Korotkov, OrioleDB, 2025-06-20: The differences between OrioleDB and Neon
• Pep Pla, Percona, 2025-07-03: A Tale of Two Databases: How PostgreSQL and MySQL Handle Torn Pages
• Shayon Mukherjee, 2025-08-09: Bypass PostgreSQL catalog overhead with direct partition hash calculations
• Amit Kapila, Fujitsu, 2025-09-24: Parallel Apply of Large Transactions
• Andrew Atkinson, 2025-09-25: What are SLRUs and MultiXacts in Postgres? What can go wrong?
• Henrietta (Hettie) Dombrovskaya, 2025-09-27: How I learned to use wal_inspect
• Hans-Jürgen Schönig, Cybertec, 2025-09-29: PostgreSQL 18 and beyond: From AIO to Direct IO?
• Nikolay Samokhvalov, PostgresAI, 2025-10-08: Fast-path locking explained
• Nikolay Samokhvalov, PostgresAI, 2025-10-10: #PostgresMarathon 2-006: Mysterious max_locks_per_transaction
• Pierre Ducroquet, Pinaraf, 2025-10-12: JIT: so you want to be faster than an interpreter on modern CPUs…
• Nikolay Samokhvalov, PostgresAI, 2025-10-13: #PostgresMarathon 2-007: Should we worry about pg_blocking_pids()’s observer effect?
• Nikolay Samokhvalov, PostgresAI, 2025-10-14: #PostgresMarathon 2-008: LWLock:LockManager and prepared statements
• Ahsan Hadi, pgEdge, 2025-11-18: Postgres 18: Skip Scan - Breaking Free from the Left-Most Index Limitation
• Radim Marek, boringSQL, 2025-12-11: VACUUM Is a Lie (About Your Indexes)
• Andrei Lepikhov, 2026-01-05: Inventing A Cost Model for PostgreSQL Local Buffers Flush
• Jimmy Angelakos, 2026-01-12: pg_statviz 0.9 released with new features
• Kaarel Moppel, 2026-01-24: CSI: Postgres — Did someone change my table??
• Jeremy Schneider, Ardent Performance Computing, 2026-02-04: Postgres client_connection_check_interval
• Jan Nidzwetzki, 2026-02-08: eBPF Tracing of PostgreSQL Spinlocks
• Jonathan Miller, 2026-02-09, MariaDB Foundation: The Real Operational Cost of Vacuuming in PostgreSQL
• Zongzhi Chen, 2026-02-09, In 2026, Can AI Modify Database Kernel Code? Rewriting PostgreSQL with Claude Code: Full Page Write vs Doublewrite Buffer, a 3x Performance Gap
• Song Zhao, Alibaba, 2026-02-16: MySQL vs PostgreSQL Internals (Part 1) – Buffer Pool
• Song Zhao, Alibaba, 2026-03-10: MySQL vs PostgreSQL Internals (Part 2) — MVCC (Multi-version Concurrency Control)
• Bruce Momjian, EnterpriseDB, 2026-03: The Wonderful World of WAL
• Lukas Fittl, 2026-04-11: Waiting for Postgres 19: Reduced timing overhead for EXPLAIN ANALYZE with RDTSC
• Lætitia Avrot, EnterpriseDB, 2026-04-15: Postgres performance regression: are we there yet?
• Radim Marek, boringSQL, 2026-04-17: PostgreSQL MVCC, Byte by Byte
• Chao Li, High Go, 2026-04-20: Understanding PostgreSQL REPACK Through repack.c
• Radim Marek, boringSQL, 2026-04-28: HOT Updates in Postgres
• Christophe Pettus, PGX, 2026-04-29: AIO Grows Up
• Radim Marek, boringSQL, 2026-07-05: VACUUM at the Page Level
• Warda Bibi, Stormatics, 2026-07-01: Inside a PostgreSQL Checkpointer Bug: A Production Postmortem
• Laurenz Albe, Cybertec, 2026-06-30: Too many tables are bad for you
• Christopher Winslett, Crunchy Data, 2026-07-16: Postgres 19 Compression: from pglz to LZ4
• Shaun Thomas, pgEdge, 2026-07-17: Looking Forward to Postgres 19: Checkpoint Control
• Radim Marek, boringSQL, 2024-07-27: PostgreSQL’s MVCC is bad. So is everyone else’s.
• Radim Marek, boringSQL, 2024-07-17: Row locks at the page level

Architecture, Design, Topologies, High Availability

• PostgreSQL Documentation: Index Types
• Radim Marek, boringSQL, 2024-05-11: Deep Dive into PostgREST - Time Off Manager (Part 1) REST, JSON, BSON
• Tudor Golubenco, Xata, 2024-05-16: Geographically distributed Postgres for multi-tenant applications
• Cary Huang, High Go, 2024-05-17: Understand PostgerSQL’s Portal – Executor vs Process Utility Optimizer
• Radim Marek, boringSQL, 2024-05-18: Deep Dive into PostgREST - Time Off Manager (Part 2) REST, JSON, BSON
• Samay Sharma (CTO), Jason Petersen (Senior Software Engineer), Tembo, 2024-05-20: Introducing pg_timeseries: Open-source time-series extension for PostgreSQL
• Semab Tariq, Stormatics, 2024-05-23: Deploying PostgreSQL Multi-Master Multi-Zone Architecture on AWS
• Radim Marek, boringSQL, 2024-05-24: Custom PostgreSQL extensions with Rust
• Semab Tariq, Stormatics, 2024-05-30: Patroni on Github Setting-up a high availability-3-node-postgresql-cluster-with-patroni-on Ubuntu 24.04
• Radim Marek, boringSQL, 2024-06-06: Deep Dive into PostgREST - Time Off Manager (Part 3)
• Semab Tariq, Stormatics, 2024-06-12: Exploring the Power of Partitioning in PostgreSQL
• Radim Marek, boringSQL, 2024-06-15: The time keepers: pg_cron and pg_timetable
• Florian Nadler, Cybertec, 2024-06-17: From Microsoft SQL server to PostGIS
• Jobin Augustine, Percona, 2024-04-24: Upgrading to the New Etcd Version From 3.3 for Patroni
• Gabriele Bartolini, 2024-06-27: Making the world my single point of failure with PostgreSQL
• PostgreSQL Cloud Extension Comparator
• Paul Laurence, 2024-07-24: Unleashing Postgres for Analytics With DuckDB Integration
• Tudor Golubenco, Xata, 2024-08-27: Postgres webhooks with pgstream CDC
• Semab Tariq, Stormatics, 2024-08-29: A Beginner’s Guide to Sharding PostgreSQL with Citus Sharding
• PostGIS: Getting Started
• Peter Morgan, 2024-09-16: A Kafka Compatible Broker With A PostgreSQL Storage Engine
• Sven Klemm, Timescale, 2024-09-18: Bridging the Gap Between Compressed and Uncompressed Data in Postgres: Introducing Compression Tuple Filtering
• TimescaleDB
• Semab Tariq, Stormatics, 2024-10-10: Transform PostgreSQL into a Columnar Database Using Citus
• Doug Hunley, 2024-10-04, Automating Highly Available PostgreSQL Clusters
• Craig Kerstiens, Crunchy Data, 2024-10-18: The future of Postgres?</> About extensions.
• Pavlo Golub, Cybertec, 2024-11-28: vip-manager v2.8 meets Patroni REST API
• Paul Ramsey, Crunchy Data, 2024-11-27: PostGIS Day 2024 Summary
• Josef Machytka, NetApp/Credativ, 2024-12-04: Unique Constraint Violations During Inserts Cause Bloat in PostgreSQL
• Marco Slot, Crunchy Data, 2024-12-17: pg_incremental: Incremental Data Processing in Postgres
• Shaun Thomas, EDB, 2024-12-20: PG Phriday: Kubernetes Killed the High Availability Star
• Jeremy Schneider, Ardent Performance Computing, 2024-12-31: Challenges of Postgres Containers
• Kumar Babu P G, Rohit Kapoor, Amazon/AWS, 2025-01-02: Querying and writing to MySQL and MariaDB from Amazon Aurora and Amazon RDS for PostgreSQL using the mysql_fdw extension, Part 2: Handling foreign objects
• Paul Ramsey, Crunchy Data, 2025-01-06: Running an Async Web Query Queue with Procedures and pg_cron
• Umair Shahid, Stormatics, 2025-03-11: When HASH partitioning works better than RANGE
• Hans-Jürgen Schönig, Cybertec, 2025-03-13: PostgreSQL: 1 trillion rows in Citus
• Paul Whalen, PG day Chicago 2025, 2025-04-25: Who Needs Kafka? Simple PubSub on Postgres Using LISTEN/NOTIFY
• Craig Kerstiens, Crunchy Data, 2025-03-18: Citus: The Misunderstood Postgres Extension - Sharding
• Karen Jex, 2025-06-02: Postgres Partitioning Best Practices
• Ahmet Gedemenli, Xata, 2025-06-20: pgstream v0.7.1: JSON transformers, progress tracking and wildcard support for snapshots - Learn how pgstream v0.7.1 transforms JSON data, improves snapshot experience with progress tracking and wildcard support.
• Semab Tariq, Stormatics, 2025-06-20: Which PostgreSQL HA Solution Fits Your Needs: Pgpool or Patroni?
• Esther Minano Sanz, Xata, 2025-07-01: Behind the scenes: Speeding up pgstream snapshots for PostgreSQL - How targeted improvements helped us speed up bulk data loads and complex schemas.
• Fernando Laudares Camargos, Percona, 2025-07-01: Testing ReadySet as a Query Cacher for PostgreSQL (Plus ProxySQL and HAproxy) Part 1: How-To
• Fernando Laudares Camargos, Percona, 2025-07-02: Testing ReadySet as a Query Cacher for PostgreSQL (Plus ProxySQL and HAproxy) Part 2: Test Results - readyset/LICENSE
• Song Zhao, 2025-08-11, Alibaba/Hopsworks: Is pgvector breaking PostgreSQL’s Repeatable Read isolation?
• Semab Tariq, Stormatics, 2025-08-08: Achieving High Availability in PostgreSQL: From 90% to 99.999%
• Stefanie Janine Stölting, ProOpenSource, 2025-08-12: PostgreSQL Extensions
• Jeremy Sztavinovszki, Cybertec, 2025-10-03: Bringing etcd to the database with Rust and pgrx
• Ibrar Ahmed, Abdul Moiz, pgEdge, 2025-10-20: Scaling Postgres
• Robert Bernier, Percona, 2025-11-20: Performing Standby Datacentre Promotions of a Patroni Cluster
• David Wheeler, ClickHouse, 2025-12-10: Introducing pg_clickhouse: A Postgres extension for querying ClickHouse
• Hans-Jürgen Schönig, Cybertec, 2025-12-09: PostgreSQL High-Availability Architectures
• Slava Sarzhan, Percona, 2025-12-30: Migrate to Freedom: Choosing a Truly Open Source PostgreSQL Operator
• Jeremy Schneider, Ardent Performance Computing, 2026-01-19: How Blocking-Lock Brownouts Can Escalate from Row-Level to Complete System Outages - pgbouncer
• Umair Shahid, Stormatics, 2026-01-20: PostgreSQL on Kubernetes vs VMs: A Technical Decision Guide
• Lætitia Avrot, 2026-01-28: Why Your HA Architecture is a Lie (And That’s Okay)
• Avinash Vallarapu, Gilles Darold, HexaCluster, 2026-01-30: Send Emails like Oracle UTL_SMTP using pg_utl_smtp for PostgreSQL
• Luca Ferrari, 2026-01-31: pgagroal 2.0.0 is available! - connection pooler
• Zongzhi Chen, 2026-02-05: Why MySQL’s Integration with DuckDB is More Elegant Than PostgreSQL’s
• Ronald Bradford, ProxySQL, 2026-03-04: Supercharge Your PostgreSQL with ProxySQL
• Shaun Thomas, pgEdge, 2026-03-06: Using Patroni to Build a Highly Available Postgres Cluster—Part 1: etcd
• qianzhen, 2026-03-10: Introducing pg_duckpipe: Real-Time CDC for Your Lakehouse
• Virender Singla, 2026-03-11: The Part of PostgreSQL We Discuss the Most — 1
• Virender Singla, 2026-03-11: The Part of PostgreSQL We Discuss the Most — 2 - PostgreSQL and Oracle Implementation
• Ben Dicken, PlanetScale, 2026-03-13: Scaling Postgres connections with PgBouncer
• Shaun Thomas, pgEdge, 2026-03-13: Using Patroni to Build a Highly Available Postgres Cluster—Part 2: Postgres and Patroni
• Umair Shahid, Stormatics, 2026-03-09: Thinking of PostgreSQL High Availability as Layers
• Hubert ‘depesz’ Lubaczewski, 2025-03-18: Waiting for PostgreSQL 19 – Allow table exclusions in publications via EXCEPT TABLE.
• Vibhor Kumar, EnterpriseDB, 2026-03-19: PostgreSQL HA Without SSH: Why Open Source efm_extension Matters in a Zero-Trust World
• David E. Wheeler, ClickHouse, 2026-03-20: pg_clickhouse 0.1.5
• Shaun Thomas, pgEdge, 2026-03-20: Using Patroni to Build a Highly Available Postgres Cluster—Part 3: HAProxy
• Umair Shahid, Stormatics, 2026-03-24: PostgreSQL High Availability on OCI: Why Your Failover Passes Every Test But Breaks in Production
• qianzhen, 2026-03-28: pg_duckpipe: What’s New in March 2026
• Ronald Bradford, ProxySQL Corp., 2026-03-30: Talking PostgreSQL with ProxySQL at Percona Live SF 2026
• Zongzhi Chen, 2026-04-07: Starting from PostgreSQL’s fsync Failure
• Laurenz Albe, Cybertec, 2026-04-07: Schemas in PostgreSQL and Oracle: what is the difference?
• Richard Yen, 2026-04-06: WAL as a Data Distribution Layer
• Lætitia Avrot, Docker Inc., 2026-04-06: PAX: The Storage Engine Strikes Back
• Pavel Stěhule, 2026-04-02: Using non ACID storage as workaround instead missing autonomous transactions
• Tudor Golubenco, Xata, 2026-04-15: Introducing Xata OSS: Postgres platform with branching, now Apache 2.0
• Rene Cannao, ProxySQL, 2026-04-18: ProxySQL for PostgreSQL — the failover model
• Rene Cannao, ProxySQL, 2026-04-21: ProxySQL for PostgreSQL — Surviving an unplanned primary failure
• Simeon Griggs, PlanetScale, 2026-04-21: Approaches to tenancy in Postgres
• Rene Cannao, ProxySQL, 2026-04-22: Orchestrator for PostgreSQL: the HA brain, now first-party
• Shaun Thomas, pgEdge, 2026-04-24: The Scaling Ceiling: When One Postgres Instance Tries to Be Everything
• Rahim Kanji, ProxySQL, 2026-04-29: Part 2 - PgBouncer to ProxySQL: A Brief Feature Comparison
• Ronald Bradford, ProxySQL, 2026-06-03: A Perfect Complement to PostgreSQL
• Shaun Thomas, pgEdge, 2026-06-19: Looking Forward to Postgres 19: Logically Sequenced
• Leo Hsu, Regina Obe, Postgres OnLine Journal, 2026-06-21: Replacing pgAgent with pg_timetable: Part 1
• Vigneshwaran C, Fujitsu, 2026-06-30: Closing a critical gap in PostgreSQL upgrade workflows with sequence synchronization
• Richard Yen, 2026-07-06: A practical guide to what .ready and .done mean, and why WAL sticks around
• Leo Hsu, Regina Obe, Postgres OnLine Journal, 2026-07-14: Replacing pgAgent with pg_timetable: Part 2 - Installing pg_timetable as a service in Linux
  • Spock on GitHub
• Nikolay: PostgreSQL SimCity
• DuckDB Extension for PostgreSQL
  • On Wikipedia
  • On Github
  • Some Benchmark ideas: Evgeniy Patlan, Percona, 2026-08-07: The DuckDB MySQL engine at 500 GB
• Umair Shahid, Stormatics, 2026-08-10: Choosing the Right PostgreSQL Partition Key
• Josh Brown, PlanetScale, 2026-08-24: The history of Postgres sharding
• Agus Syafaat, Serveal 9s, 2026-08-26: Postgres + ClickHouse Architectural Patterns
• Josh Brown, PlanetScale, 2026-08-18: Poisoned Postgres connection pools
• Elizabeth Garrett Christensen, Snowflake, Tom Lane, Snowflake/Retired?: 2026-09-09: Tom Lane on the Architectural Decisions That Shaped 30 Years of Postgres - The dirty little secret here is that if one process crashes, we take down all the rest anyway, because we aren’t totally certain that that one process didn’t manage to corrupt anything in shared memory before it actually failed.
• Joshua D. Drake, Command Prompt, Inc., 2026-09-17: pgColumnar 1.0-alpha4 release notes
• Christophe Pettus, PGX, 2026-09-22: The Shadow Knows
• Chris van Eijk, Now-Next, 2026-09-22: Multi-tenant SaaS on PostgreSQL: six decisions - The six choices a multi-tenant SaaS locks into PostgreSQL: isolation model, RLS, indexes, money, restoring one tenant and migrating at scale. All measured.

Replication

• Christophe Pettus, PGX, Nordic PGDay 2023: Real-World Logical Replication
• Semab Tariq, Stormatics, 2024-05-17: Understanding Synchronous and Asynchronous Replication in PostgreSQL – What is Best for You?
• Shayon Mukherjee, 2024-07-13: Use pg_easy_replicate for setting up Logical Replication and Switchover in PostgreSQL
• Hayato Kuroda, Fujitsu, 2024-08-22: New logical replication features in PostgreSQL 17
• Shayon Mukherjee, 2024-08-31: pg_easy_replicate Supports Schema Change Tracking During Logical Replication
• Stefan Fercot, Data Egret, 2024-09-05: PITR and Streaming Replication environments
• Gabriele Bartolini, 2024-09-10: Configuring PostgreSQL Synchronous Replication
• Umair Shahid, Stormatics, 2024-09-10: Understanding Factors Impacting Data Replication Latency in PostgreSQL Across Geographically Distributed Nodes
• Amit Kapila, Fujitsu, 2024-09-25: Online Upgrading Logical and Physical Replication Nodes
• Amit Kapila, Fujitsu, 2024-10-03: Failover Slots in PostgreSQL-17: Ensuring High Availability with Logical Replication
• Semab Tariq, Stormatics, 2024-10-17: Implementing Bi-Directional Replication in PostgreSQL
• Kaarel Moppel, 2024-12-09: Postgres Synchronous Replication - a 99.99% guarantee only
• Ants Aasma, Cybertec, 2025-02-18: End of the road for PostgreSQL streaming replication?
• Avinash Vallarapu, HexaCluster, 2025-03-06: Streaming Replication Internals for High Availability in PostgreSQL
• Ahsan Hadi, pgEdge, 2025-05-07: Unleashing the Power of PostgreSQL with pgEdge Distributed Multi-Master Replication and Postgres Platform - Part 1
• Ashutosh Bapat, 2025-06-06: Avoiding disk spills due to PostgreSQL’s logical replication
• Radim Marek, boringSQL, 2025-06-11: First steps with Logical Replication in PostgreSQL
• Jan Wieremjewicz, Percona, 2025-06-18: PostgreSQL active-active replication, do you really need it? - pgactive
• Radim Marek, boringSQL, 2025-06-24: Beyond the Basics of Logical Replication
• Jan Wieremjewicz, Percona, 2025-07-10: Active-active replication - the hidden costs and complexities
• Semab Tariq, Stormatics, 2025-07-10: Replication Types and Modes in PostgreSQL
• Shiv Iyer, MinervaDB, 2025-08-05: Mastering PostgreSQL Replication: A Complete Guide for Database Professionals
• Semab Tariq, Stormatics, 2025-08-22: Cold, Warm, and Hot Standby in PostgreSQL: Key Differences
• Jeremy Schneider, Ardent Performance Computing, 2025-09-01: Run Jepsen against CloudNativePG to see sync replication prevent data loss
• Jeremy Schneider, Ardent Performance Computing, 2025-10-02: Postgres Replication Links
• Andrei Lepikhov, 2025-10-18: Revising the Postgres Multi-master Concept - Does logical replication have hidden potential?
• Esther Minano Sanz, Xata, 2025-11-26: pgstream v0.9.0: Better schema replication, snapshots and cloud support - Bringing connection retries, anonymizer features, memory improvements and solid community input.
• Umut Tekin, Cybertec, 2026-01-06: Exploration: CNPG Logical Replication in PostgreSQL
• Esther Minano Sanz, xata, 2026-02-04: pgstream v1.0.0: Stateless schema change replication - A major architectural milestone that removes schema logs and simplifies how pgstream captures and replicates Postgres schema changes
• Umut Tekin, Cybertec, 2026-03-31: Patroni: Cascading Replication with Stanby Cluster
• Gabriele Bartolini, 2026-04-14: Owning the pipe: physical replication, cloud neutrality, and the escape from DBaaS lock-in
• Jobin Augustine, Percona, 2026-04-30: Troubleshooting logical replication delay made easy
• Zhijie Hou, Fujitsu, 2026-05-28: How to hack Logical Replication in PostgreSQL: Insights from contributors - Logical replication has come a long way since its introduction in PostgreSQL. It is now being adopted more widely than ever, powering cross-version upgrades, multi-region deployments, and real-time analytics pipelines. Yet significant opportunities for improvement still remain.
• Semab Tariq, Stormatics, 2026-06-12: When Patroni Silently Deletes Your Replication Slots
• Semab Tariq, Stormatics, 2026-06-16: How To Run Logical Replication On A Production PostgreSQL Cluster
• Marcelo Hauschild, Fujitsu, 2026-07-05: How Fujitsu helps drive PostgreSQL forward with code-level contributions and features - For more than two decades, Fujitsu has been an active participant in the PostgreSQL project, not as a downstream consumer, but as a contributor shaping how the database evolves. From early feature development to today’s work on logical replication, conflict resolution, and zero downtime operations, Fujitsu engineers have consistently contributed code, reviews, and design insight upstream.
• Antony Pegg, pgEdge, 2026-07-16: Spock 6: The Only Logical Choice - multi-master replication
• Hayato Kuroda, Fujitsu, 2026-07-28: Highlights of Fujitsu’s contribution in PostgreSQL 19 - Fujitsu’s PostgreSQL team helped shape PostgreSQL 19 through sustained code contributions, community recognition, and new improvements in logical replication. Take a closer look at Fujitsu’s growing impact and ongoing commitment to advancing open-source database innovation.
• Christophe Pettus, PGX, 2026-07-31: All Your GUCs in a Row: hot_standby_feedback
• Christophe Pettus, PGX, 2026-08-03: All Your GUCs in a Row: idle_replication_slot_timeout
• Gaoxueyu Hope, Hornetlabs Technology Inc., 2026-08-12: SynchDB 1.4 Released - Oracle Container Database Support and TLS-Secured FDW Snapshots
• Christophe Pettus, PGX, 2026-09-02: All Your GUCs in a Row: log_replication_commands
• Mikhail Shytsko, Seedfast, 2026-09-04: What Replica Mode Does Not Switch Off
• Christophe Pettus, PGX, 2026-09-09: All Your GUCs in a Row: max_active_replication_origins
• Shaun Thomas, pgEdge: 2026-09-11: PG Phriday: The Folder That Ate the Publisher
• Christophe Pettus, PGX, 2026-09-16: All Your GUCs in a Row: max_logical_replication_workers
• Christophe Pettus, PGX, 2026-09-20: All Your GUCs in a Row: max_parallel_apply_workers_per_subscription
• Dimitri Fontaine, Neon, 2026-09-22: Ten years of Postgres logical replication

Operations

• Laurenz Albe, Cybetec, 2021-02: Estimating connection pool size with PostgreSQL database statistics
• Nikolay Samokhvalov, PostgresAI, 2023-09-27: How to troubleshoot and speed up Postgres stop and restart attempts
• Nikolay Samokhvalov, PostgresAI, 2023-09-28: How to troubleshoot long Postgres startup
• Greg Nokes, Crunchy Data, 2024-05-30: Data Encryption in Postgres: A Guidebook
• Brian Pace, Crunchy Data, 2024-05-31: Introducing pgcompare the ultimate multi database data comparison tool
  On GitHub
• Hans-Jürgen Schönig, Cybertec, 2024-07: Speeding up index creation in PostgreSQL
• Tomas Vondra, EnterpriseDB, 2024-07-15: Autovacuum Tuning Basics
• Andrew Atkinson, 2024-07-23: Wait a minute! — PostgreSQL extension pg_wait_sampling
• Jesse Soyland, Crunchy Data, 2024-08-09: Postgres Troubleshooting - DiskFull ERROR could not resize shared memory segment
• Hans-Jürgen Schönig, Cybertec, 2024-09-01: VACUUM: Managing and detecting bloat
• Semab Tariq, Stormatics, 2024-09-03: Deploying Your First PostgreSQL Clusters on Kubernetes with Cloud Native Postgres
• Andrew Atkinson, 2024-09-06: Shrinking Big PostgreSQL tables: Copy-Swap-Drop
• Nikolay Samokhvalov, PostgresAI, 2024-10-03: AI-assisted Postgres experiment: number of partitions vs. planning time
• Damien Clochard, Dalibo, 2024-10-15: PostgreSQL Anonymizer 2.0 - Generating Fake Data
• Kaarel Moppel, 2024-11-05: Cloning Postgres user privileges vs ChatGPT
• Andrew Farries, Xata, 2024-11-13: Schema changes and the power of expand-contract with pgroll
  A pgconf EU talk recap covering how the expand-contract pattern and pgroll enable zero-downtime schema changes and rollbacks.
• Christophe Pettus, PGX, 2024-11-15: The Doom That Came To PostgreSQL: When Collations Change
• Christophe Pettus, PGX, 2024-11-22: Locale Cooking: Common Scenarios and Suggestions
• Christophe Pettus, PGX, 2024-11-20: Talk Fast: The Speed of Various Collations
• Hubert ‘depesz’ Lubaczewski, 2024-12-12: How to ALTER tables without breaking application?
• Umair Shahid, Stormatics, 2024-12-13: VACUUM FULL in PostgreSQL – What you need to be mindful of
• Andrei Lepikhov, 2024-12-15: Fractional Path Issue in Partitioned Postgres databases - Continuing discovery on Postgres planner weak points
• Shane Borden, 2024-12-17: Some of My Favorite Things – Postgres Queries - Top SQL, Vacuum
• Hubert ‘depesz’ Lubaczewski, 2025-01-06: Waiting for PostgreSQL 18 – Allow changing autovacuum_max_workers without restarting
• Umair Shahid, Stormatics, 2025-01-09: Idle Transactions Cause Table Bloat? Wait, What?
• Umair Shahid, Stormatics, 2025-01-23: Leveraging autovacuum in PostgreSQL to optimize performance and reduce costs
• Greg Sabino Mullane, Crunchy Data, 2025-01-27: When Does ALTER TABLE Require a Rewrite?
• Christophe Pettus, PGX, 2025-01-28: VACUUM (INDEX_CLEANUP OFF) Considered Harmful
• Doug Hunley, Crunchy Data, 2025-03-01: I Heard You Like Releases in Your Releases
• Greg Sabino Mullane, Crunchy Data, 2025-03-19: Postgres Troubleshooting: Fixing Duplicate Primary Key Rows
• Kaarel Moppel, 2025-03-27: TIL - Starting in read-only mode the easy way
• Kaarel Moppel, 2025-04-10: A roadmap to scaling Postgres
• Bruce Momjian, EnterpriseDB: 2025-04: User, User, Who Is the User?
• Kuntal Ghosh, 2025-04-27: Exploring the limits of Postgres
• Daria Nikolaenko, Data Egret, 2025-04-28: Taming large datasets in PostgreSQL: archiving and retention without the pain
• Laurenz Albe, Cybertec, 2025-04-29: Orphaned files after a PostgreSQL crash
• Pavlo Golub, Cybertec, 2025-04-30: PostgreSQL Trusted Extensions for Beginners
• Hans-Jürgen Schönig, Cybetec, 2025-05-06: CREATE INDEX: Data types matter
• Tianzhou, 2025-05-23: What’s New in PostgreSQL 18 - a DBA’s Perspective
• Shiv Iyer, MinervaDB, 2025-06-03: PostgreSQL 18 IOPS Optimization
• Shane Borden, 2025-06-06: Understanding High Water Mark Locking Issues in PostgreSQL Vacuums
• Umair Shahid, Stormatics: 2025-06-10: Checklist: Is Your PostgreSQL Deployment Production-Grade?
• Shiv Iyer, MinervaDB, 2025-06-11: Troubleshooting PostgreSQL Page Corruption
• Shiv Iyer, MinervaDB, 2025-06-27: PostgreSQL Threat Modeling for FinTech
• Laurenz Albe, Cybertec, 2025-08-12: Should I rebuild my PostgreSQL index?
• Elizabeth Christensen, Crunchy Data, 2025-08-19: Postgres Logging for Performance Optimization
• Shiv Iyer, MinervaDB, 2025-08-26: PostgreSQL VACUUM Guide: Complete Best Practices for Database Maintenance
• Tudor Golubenco, Xata, 2025-09-29: Going down the rabbit hole of Postgres 18 features - A comprehensive list of PostgreSQL 18 new features, performance optimizations, operational and observability improvements, and new tools for devs.
• Semab Tariq, Stormatics, 2025-10-10: Don’t Skip ANALYZE: A Real-World PostgreSQL Story
• Umair Shahid, Stormatics, 2025-10-17: Configuring Linux Huge Pages for PostgreSQL
• Tomas Vondra, 2025-10-31: Don’t give Postgres too much memory
• Jan Wieremjewicz, Percona, 2025-11-28: TDE is now available for PostgreSQL 18
• Antony Pegg, pgEdge, 2025-12-12: Zero-Downtime PostgreSQL Maintenance with pgEdge
• Radim Marek, boringSQL, 2025-12-22: Instant database clones with PostgreSQL 18
• Tomas Vondra, 2025-12-23: Don’t give Postgres too much memory (even on busy systems)
• Deepak Mahto, 2026-01-05: PostgreSQL Table Rename and Views – An OID Story
• Josef Machytka, Creadativ, 2026-01-06: Dissecting PostgreSQL Data Corruption
• Hubert ‘depesz’ Lubaczewski, 2026-01-07: Quick and dirty loading of CSV files
• Shinya Kato, 2026-01-20: 4 causes of table bloat in PostgreSQL and how to address them
• Chao Li, High Go, 2026-01-21: Understanding ALTER TABLE Behavior on Partitioned Tables in PostgreSQL
• Semab Tariq, Stormatics, 2026-01-27: Unused Indexes In PostgreSQL: Risks, Detection, And Safe Removal
• Jobin Augustine, Percona, 2026-02-02: Importance of Tuning Checkpoint in PostgreSQL
• Lætitia Avrot, EnterpriseDB, 2026-03-11: work_mem: it’s a trap!
• Shane Borden, 2026-03-13: More Obscure Things That Make It Go “Vacuum” in PostgreSQL
• Hubert ‘depesz’ Lubaczewski, 2026-03-19: Waiting for PostgreSQL 19 – Introduce the REPACK command - Cluster Index
• Deepak Mahto, 2026-03-21: PostgreSQL Sequence Reset: START WITH vs RESTART WITH vs SETVAL Explained
• Lætitia Avrot, Docker Inc., 2026-03-31: pg_service.conf: the spell your team forgot to learn
• Elizabeth Garrett Christensen, Erik Jones, Snowflake, 2026-03-31: Do You Need to Tune Postgres Vacuum?
• Shaun Thomas, pgEdge, 2026-04-03: What is a Collation, and Why is My Data Corrupt?
• Lætitia Avrot, Docker Inc., 2026-04-07: pg_column_size(): What you see is not what you get
• Warda Bibi, Stormatics, 2026-04-09: The 1 GB Limit That Breaks pg_prewarm at Scale
• Simeon Griggs, PlanetScale, 2026-04-10: Keeping a Postgres queue healthy
• Shaun Thomas, pgEdge, 2026-04-10: Checkpoints, Write Storms, and You
• Jeremy Schneider, Ardent Performance Computing, 2026-04-12: Zero autovacuum_vacuum_cost_delay, Write Storms, and You
• Mark Callaghan, 2026-04-14: Postgres vs Linux 7.0 in the new - Huge pages
• Christophe Pettus, PGX, 2026-04-22: All your GUCs in a row: allow_system_table_mods
• Christophe Pettus, PGX, 2026-04-23: Async I/O in PostgreSQL 19: The Year After
• Christophe Pettus, PGX, 2026-04-23: PREEMPT_NONE Is Dead; Your Postgres Probably Doesn’t Care
• Christophe Pettus, PGX, 2026-04-23: All Your GUCs in a Row: application_name
• Christophe Pettus, PGX, 2026-04-24: Postgres Goes to the Lake, Two Ways
• Christophe Pettus, PGX, 2026-04-24: Huge Pages, End to End
• Christophe Pettus, PGX, 2026-04-24: All your GUCs in a Row: archive_cleanup_command
• Christophe Pettus, PGX, 2026-04-25: All Your GUCs in a Row: archive_command
• Christophe Pettus, PGX, 2026-04-26: All Your GUCs in a Row: archive_library
• Christophe Pettus, PGX, 2026-04-27: All Your GUCs in a Row: archive_mode
• Christophe Pettus, PGX, 2026-04-27: Retail DDL Arrives, One Function at a Time
• Christophe Pettus, PGX, 2026-04-27: Online Checksums Are Not Instant
• Christophe Pettus, PGX, 2026-04-28: All Your GUCs in a Row: archive_timeout
• Christophe Pettus, PGX, 2026-04-28: Parallel Autovacuum: It’s Not About The CPU
• Christophe Pettus, PGX, 2026-04-29: All Your GUCs in a Row: array_nulls
• Christophe Pettus, PGX, 2026-04-29: REPACK Moves In
• Payal Singh: 2026-05-27: Postgres War Stories Part 1: Postgres outages that aren’t Postgres bugs - Three OS-level failures that show up as database outages, and what to put in the runbook before you hit them.
• Christophe Pettus, PGX, 2026-06-04: All Your GUCs in a Row: data_checksums
• Robins Tharakan, 2026-06-15: Why Postgres Doesn’t Have remote_receive - And What Happened When I Tried It
• Payal Singh: 2026-06-16: Postgres War Stories Part 2: multixact wraparound, TOAST corruption, and torn pages - Three ways data goes wrong inside Postgres with nothing in the log, and the jobs that catch it before a user does.
• Christophe Pettus, PGX, 2026-06-19: All Your GUCs in a Row: dynamic_shared_memory_type
• Christophe Pettus, PGX, 2026-06-20: All Your GUCs in a Row: effective_cache_size
• Christophe Pettus, PGX, 2026-06-21: All Your GUCs in a Row: effective_io_concurrency
• Jan Nidzwetzki, Etienne Berube, Ahmed Darwich, PlanetScale, 2026-07-20: Every UPDATE Leaves a Ghost: MVCC, Bloat, and VACUUM in PostgreSQL
• Christophe Pettus, PGX, 2026-07-20: All Your GUCs in a Row: file_copy_method
• Shridhar Khanal, Stormatics, 2026-07-23: The Right Way to Give a Third-Party DBA Access to Your PostgreSQL Database
• Shaun Thomas, pgEdge, 2026-07-24: Looking Forward to Postgres 19: Autovacuum Tweaks
• Vibhor Kumar, EDB, 2026-07-27: The CALM Platform Test - Why Enterprise Platforms Often Fail Long Before They Break
• Pavlo Golub, Cybertec, 2026-07-30: vip-manager v5 is out: what you need to know
• Umair Shahid, Stormatics, 2028-08-03: PostgreSQL Lockup vs Stale Connection: How to Tell Them Apart
• Christophe Pettus, PGX, 2026-08-23: All Your GUCs in a Row: listen_addresses
• Christophe Pettus, PGX, 2026-08-24: All Your GUCs in a Row: log_checkpoints, log_autovacuum_min_duration, and log_temp_files
• Christophe Pettus, PGX, 2026-08-25: All Your GUCs in a Row: log_connections, log_disconnections, and log_hostname
• Simeon Griggs, PlanetScale, 2026-08-25: Problems with large tables in Postgres
• Christophe Pettus, PGX, 2026-08-26: All Your GUCs in a Row: log_destination and logging_collector
• Semab Tariq, Stormatics, 2026-08-27: How to Calculate Fillfactor for Your Tables
• Christophe Pettus, PGX, 2026-08-27: All Your GUCs in a Row: log_directory, log_filename, and log_file_mode
• Christophe Pettus, PGX, 2026-08-28: All Your GUCs in a Row: log_rotation_age, log_rotation_size, and log_truncate_on_rotation
• Christophe Pettus, PGX, 2026-08-29: All Your GUCs in a Row: log_line_prefix and log_timezone
• Christophe Pettus, PGX, 2026-08-30: All Your GUCs in a Row: log_min_messages, log_min_error_statement, and log_error_verbosity
• Christophe Pettus, PGX, 2026-08-31: All Your GUCs in a Row: log_parameter_max_length and log_parameter_max_length_on_error
• Christophe Pettus, PGX, 2026-09-01: All Your GUCs in a Row: log_min_duration_sample, log_statement_sample_rate, and log_transaction_sample_rate
• Christophe Pettus, PGX, 2026-09-03: All Your GUCs in a Row: log_lock_waits and log_lock_failures
• Christophe Pettus, PGX, 2026-09-04: All Your GUCs in a Row: log_startup_progress_interval and log_recovery_conflict_waits
• Christophe Pettus, PGX, 2026-09-05: All Your GUCs in a Row: log_parser_stats, log_planner_stats, log_executor_stats, and log_statement_stats
• Umair Shahid, Stormatics, 2026-09-03: Database Availability Is a Stack: Rolling OS Patching
• Christophe Pettus, PGX, 2026-09-10: All Your GUCs in a Row: max_connections
• Christophe Pettus, PGX, 2026-09-11: All Your GUCs in a Row: max_files_per_process
• Christophe Pettus, PGX, 2026-09-15: [https://thebuild.com/blog/all-your-gucs-in-a-row-max_locks_per_transaction/](All Your GUCs in a Row: max_locks_per_transaction)
• Christophe Pettus, PGX, 2026-09-17: The Call Is Coming From Inside the Session
• Christophe Pettus, PGX, 2026-09-18: All Your GUCs in a Row: max_parallel_maintenance_workers
• Christophe Pettus, PGX, 2026-09-19: All Your GUCs in a Row: max_parallel_workers and max_parallel_workers_per_gather
• Christophe Pettus, PGX, 2026-09-22: All Your GUCs in a Row: max_pred_locks_per_transaction
• Christophe Pettus, PGX, 2026-09-21: All Your GUCs in a Row: max_pred_locks_per_page and max_pred_locks_per_relation

Backup, Restore, Recovery

• Laurenz Albe, Cybertec, 2022-08: How to corrupt your PostgreSQL database
• Stormatics, 2023-05-22: PostgreSQL Backup Best Practices
• Gulcin Yildirim Jelinek, Xata, 2024-08-23: If pg_dump is not a backup tool, what is? - pg_dumps was a utility for backing up a PostgreSQL database, not anymore
• Brian Pace, Crunchy Data, 2024-09-05: PostgreSQL Snapshots and Backups with pgBackRest in Kubernetes
• Grant Fritchey, Redgate Software: 2024-09-07: PostgreSQL Backups to Support Point In Time Recovery: Learning PostgreSQL with Grant
• Stefan Fercot, Data Egret, 2024-09-23: pgBackRest backups from the standby server
• Stefan Fercot, Data Egret, 2024-09-25: pgBackRest dedicated backup host
• Marat Bogatyrev, Dataegret, 2024-11-07: From Backup to Integrity: Leveraging WAL-G for PostgreSQL
• Stefan Fercot, Data Egret, 2024-11-28: Combining cloud storage and dedicated backup host with pgBackRest
• Stefan Fercot, Data Egret, 2025-02-13: pgBackRest preview: verify recovery target timeline on restore
• Ibrar Ahmed, pgEdge, 2025-04-22: 8 Steps to Proactively Handle PostgreSQL Database Disaster Recovery
• Dave Stokes, 2025-04-26: Incremental Backups in PostgreSQL 17
• Semab Tariq, Stormatics, 2025-06-27: Choosing the Right Barman Backup Type and Mode for Your PostgreSQL Highly Available Cluster
• Warda Bibi, Stormatics, 2025-07-03: Disaster Recovery Guide with pgbackrest - pgBackRest
• Warda Bibi, Stormatics, 2025-09-01: The Hidden Bottleneck in PostgreSQL Restores and its Solution
• Warda Bibi, Stormatics, 2025-10-15: Understanding Disaster Recovery in PostgreSQL
• Stefan Fercot, 2025-11-17: pgBackRest TLS server mode for a primary-standby setup with a repository host
• Stefan Fercot, Data Egret, 2025-12-11: pgBackRest PITR in Docker: a simple demo
• Stefan Fercot, Data Egret, 2025-12-17: pgBackRest preview - simplifying manual expiration of oldest backups
• Imran Zaheer, Cybertec, 2025-12-30: PostgreSQL Recovery Internals
• Zhang Chen, 2026-01-09: Not a Backup Replacement: What PostgreSQL Instant Recovery Actually Solves
• Zhang Chen, 2026-01-09: How to Turn PostgreSQL Unconventional Recovery into an Elegant Art
  PostgreSQL Data Unloader
• Christophe Pettus, PGX, 2026-04-27: Notice of Obsolescence - pgBackRest
• Lætitia Avrot, EnterpriseDB, 2026-04-27: pgBackRest is dead. Now what?
• Richard Yen, 2026-06-15: Disaster Recovery is a Process, Not a Tool (Part 1)
• Hans-Jürgen Schönig, Cybertec, 2026-06-23: Introducing pg_hardstorage: A New Community-Driven Approach to PostgreSQL Backup and Recovery
• Dimitri Fontaine, Neon, 2026-07-01: pgcopydb v0.18
• Zhang Chen, 2026-07-01: The PostgreSQL Feature That Makes Data Recovery Painful
• Zhang Chen, 2026-07-02: Extreme Rescue: PostgreSQL Full-File Ransomware Recovery at Epic Difficulty
• Shridhar Khanal, Stormatics, 2026-07-07: PostgreSQL Disaster Recovery with pgBackRest TLS Transport - SSH Gets the Job Done Securely. TLS Can Help at Scale.
• Daniel Guzman-Burgos, dbtrail, 2026-07-15: Time-travel for PostgreSQL: one SELECT vs a full restore vs replaying the WAL
• Hans-Jürgen Schönig, Cybertec, 2026-07-16: Philosophy behind pg_hardstorage
• Hans-Jürgen Schönig, Cybertec, 2026-07-20: Moving to pg_hardstorage without changing your recovery strategy
• Oli Sennhauser/Shinugz, FromDual, 2026-07-22: PostgreSQL Point-in-Time Recovery with Oops-Queries
• Josh Brown, PlanetScale, 2026-07-24: Postgres backups under the hood
• Ben Dicken, PlanetScale, 2027-07-31: Massively parallel Postgres backups
• Christophe Pettus, PGX, 2026-08-06: All Your GUCs in a Row: ignore_invalid_pages
• Christophe Pettus, PGX, 2026-08-05: All Your GUCs in a Row: ignore_checksum_failure
• Christophe Pettus, PGX, 2026-08-07: All Your GUCs in a Row: ignore_system_indexes - Recovery of System Catalog
• Zhang Chen, 2026-08-09: Why I Dare to Call Myself a “PostgreSQL Database Recovery Expert” - After becoming a PostgreSQL ACE, Zhang Chen explains why he uses the title “PostgreSQL Database Recovery Expert” and how PDU evolved from offline extraction and WAL mining to fragment scanning and recovery without a data dictionary.
  • PostgreSQL Data Unloader (PDU) on Github
• Mikhail Shytsko, Seedfast, 2026-08-28: The Dump That Breaks Its Own Restore
• Jimmy Angelakos, pgEdge, 2026-09-09: 100,000 Lines of C Later: pgSafe at PGDay UK 2026
• Percona, 2026-09-09: Meet pgstef: Why Stefan Fercot Joined Percona, and Why You Should Find Him at Percona Live Amsterdam
• Stefan Fercot, Percona, 2026-09-23: pgBackRest and PostgreSQL failover: why archive_mode matters

Security

• Sagar Jadhav, Percona, 2024-08-06: Dispelling Myths About PostgreSQL Default Privileges
• Hans-Jürgen Schönig, Cybertec, 2024-08-06: Enhanced security: Logging PostgreSQL connections
• Elizabeth Christensen, Crunchy Data, 2025-03-25: Postgres Security Checklist from the Center for Internet Security
• Jan Wieremjewicz, Percona, 2025-03-28: Transparent Data Encryption for PostgreSQL Release Candidate is Here!
• Christophe Pettus, PGX, 2025-04-02: Do not expose port 5432 to the public Internet
• Assaf Morag, Aqua Security Software Inc., 2025-08-19: PG_MEM: A Malware Hidden in the Postgres Processes
• Thom Brown, 2025-04-04: Don’t let your PostgreSQL get exploited
• Shiv Iyer, MinervaDB, 2025-06-23: Securing User Accounts in PostgreSQL
• Andreas ‘ads’ Scherbaum, 2025-06-30: Performance Test for Percona Transparent Data Encryption (TDE)
• Jan Wieremjewicz, Percona, 2025-06-30: The PG_TDE Extension Is Now Ready for Production
• Tomas Vondra, 2025-08-27: Using JWT to establish a trusted context for RLS
• Jan Wieremjewicz, Percona, 2025-09-01: pg_tde can now encrypt your WAL on PROD!
• Dan Langille, 2025-11-13: PostgreSQL: MD5 password support is deprecated – updating the user passwords
• Henrietta (Hettie) Dombrovskaya. 2026-01-06: pg_acm is here!
• Goutham Banala, HexaCluster, 2026-02-12: Row-level and Column-level Security - Oracle vs PostgreSQL
• Vibhor Kumar, EnterpriseDB, 2026-03-12: Transparent Column Encryption in PostgreSQL: Security Without Changing Your SQL
• Tudor Golubenco, Xata, 2026-08-11: Multi-tenant BYOK encryption in PostgreSQL with pgcrypto - Implement multi-tenant BYOK column encryption in PostgreSQL with pgcrypto using customer-managed encryption keys.
• Umair Shahid, 2026-08-28: How Fast Should You Patch Production PostgreSQL?
• PostgreSQL Anonymizer - Anonymization & Data Masking for Postgres
• 2026-09-10: pg_vault_tde: Transparent Data Encryption for PostgreSQL 17 and 18

Upgrade

• Paolo Melchiorre, 2024-05-20: Upgrade PostgreSQL from 15 to 16 on Ubuntu 24.04
• Carlos Pérez-Aradros Herce, Xata, 2024-07-18: Postgres major version upgrades with minimal downtime
• Shaun Thomas, Tembo, 2024-11-05: Plugging the Postgres Upgrade Hole
• Peter Eisentraut, EnterpriseDB, 2024-11-26: Why PostgreSQL major version upgrades are hard
• Gabriele Bartolini, EnterpriseDB, 2024-12-11: CNPG Recipe 15 - PostgreSQL major online upgrades with logical replication - Unleashing the Power of Postgres in Kubernetes
• Ahsan Hadi, pgEdge, 2025-01-27: Preserving replication slots across major Postgres versions - PostgreSQL high availability for major upgrades
• Gabriele Bartolini, EnterpriseDB, 2025-04-03: CNPG Recipe 17 - PostgreSQL In-Place Major Upgrades
• Paolo Melchiorre, 2025-05-07: Upgrade PostgreSQL from 16 to 17 on Ubuntu 25.04
• Laurenz Albe, Cybertec, 2025-06-17: Preserve optimizer statistics during major upgrades with PostgreSQL v18
• Greg Sabino Mullane, Crunchy Data, 2025-12-11: Postgres 18 New Default for Data Checksums and How to Deal with Upgrades
• Andrew Dunstan, EnterpriseDB, 2025-12-12: How does the PostgreSQL Buildfarm check upgrades across versions?
• Laurenz Albe, Cybertec, 2025-12-16: Which indexes can be corrupted after an operating system upgrade?
• Ilya Kosmodemiansky, Data Egret, 2026-03-19: An Ultimate Guide to Upgrading Your PostgreSQL Installation: From 17 to 18
• Just Stuff Blog, 2026-07-13: PostgreSQL nach dem Distributions-Upgrade: „Version von Sortierfolge stimmt nicht überein“
• Shridhar Khanal, Stormatics, 2026-07-16: Upgrading PostgreSQL 9.6 to 17 with pg_upgrade

Migration

• Uber Engineering, 2016-05-26: Why Uber Engineering Switched from Postgres to MySQL PostgreSQL 8.3 (2008) - 9.3 (2013) vs MySQL 5.7 (2015 - 2023)
• Florent Jardin, 2024-05-28: An assistant to copy data from a remote server
• Umair Shahid, Stormatics, 2024-10-04: Transitioning from Oracle to PostgreSQL: Tablespaces
• Umair Shahid, Stormatics, 2024-10-28: Transitioning from Oracle to PostgreSQL: PL/SQL vs PL/pgSQL
• Deepak Mahto, 2024-11-10: Understanding Volatility in PL/pgSQL Functions: A Real-World Lesson
• Laurenz Albe, Cybertec, 2025-02: Comparison of the transaction systems of Oracle and PostgreSQL
• Bradley Tollett, 2025-07-30: MySQL to PostgreSQL: The Ultimate Transition Guide
• Elizabeth Christensen, Crunchy Data, 2025-10-03: Postgres Migrations Using Logical Replication
• Avinash Vallarapu, HexaCluster, 2026-01-14: New PostgreSQL Tools and Extensions announced in 2025 - oid2bytea, Ora2Pg, pgBadger, credcheck, pg_dbms_errlog, pg_statement_rollback, pg_dump binary, pgFormatter, squidclamav, pgtt, external_file
• Akhil Reddy Banappagari, HexaCluster, 2026-01-19: The DATE Data Type in Oracle vs. PostgreSQL
• Akhil Reddy Banappagari, HexaCluster, 2026-01-31: Null and Empty String in Oracle vs SQL Server vs PostgreSQL
• Deepak Mahto, 2026-01-30: Same SQL, Different Results: A Subtle Oracle vs PostgreSQL Migration Bug
• Jeremy Schneider, Ardent Performance Computing, 2025-03-25: Database Schema Migrations in 2026 – Survey
• Deepak Mahto, 2026-03-27: Oracle & SQL Server to PostgreSQL – Migration Tooling Gotchas No One Warns You About!
• Deepak Mahto, 2026-03-31: Why Ora2Pg Should Be Your First Stop for PostgreSQL Conversion
• 2026-09-07: PostgreSQL Migrator 1.0 : first stable release - PostgreSQL Migrator supports migrating from Oracle Database 11g to 26ai, MySQL 8.4+ and MariaDB 10+ to PostgreSQL 16 up to 19.
• Umair Shahid, Stormativs, 2026-09-10: How to De-Risk a Mission-Critical PostgreSQL Migration
• Florent Jardin, 2026-09-16: Inspecting a catalog with pg_migrate

Monitoring

• PlanetScale: Cluster Metrics
• Grant Fritchey, Redgate Software, 2025-02-13: Free PostgreSQL Performance Monitoring with pgNow
• Javier Jaramago Fernandez, ProxySQL, 2025-08-29: PostgreSQL Monitoring with ProxySQL
• Simeon Griggs, PlanetScale, 2026-03-30: High memory usage in Postgres is good, actually
• Ahsan Hadi, pgEdge, 2026-07-01: Introducing pg-healthcheck: PostgreSQL Health Diagnostics
• Pavlo Golub, Cybertec, 2026-07: Monitoring PostgreSQL made simple
• Ryan Booz, pganalyze, 2026-09-17: Postgres Monitoring for SQL Server DBAs: Statistics and Logs 101

Cloud

• Gabriele Bartolini, 2026-08-06: CNPG Recipe 26 - Extension image catalogs - Unleashing the Power of Postgres in Kubernetes
• Wellingtone Luvonga, Cybertec, 2026-08-11: Multi-Region PostgreSQL Disaster Recovery and Failback with Crunchy PGO

Performance, Query tuning

• Deepak Mahto, 2024-05-23: Optimizing Performance in PostgreSQL: Join Column and ANY Filters
• Hubert ‘depesz’ Lubaczewski, 2024-06-11: How much speed you’re leaving at the table if you use default locale? Character set, collation, locale
• Semab Tariq, Stormatics, 2024-07-03: Key PostgreSQL Configuration Parameters for Enhanced Performance
• Semab Tariq, Stormatics, 2024-07-22: A Follow up on Key PostgreSQL Configuration Parameters for Enhanced Performance – Part 2
• Grant Fritchey, ScaryDBA, 2024-08-05: PostgreSQL and Instrumentation
• Deepak Mahto, 2024-08-27: Exploring PostgreSQL 17: A Developer’s Guide – Part 5 : Correlated IN Clause Transformation
• Semab Tariq, Stormatics, 2024-09-12: Optimizing PostgreSQL with Composite and Partial Indexes: A Quick Comparison
• Mark Callaghan, 2024-09-24: Configuration options that make writes faster or slower with MySQL and Postgres
• Shaun Thomas, Tembo, 2024-10-10: Comparing Columnar to Heap Performance in Postgres with pg_timeseries. Hydra columnar storage
• Greg Smith, Crunchy Data, 2024-11-19: Loading the World! OpenStreetMap Import In Under 4 Hours
• Tomas Vondra, Microsoft, 2024-11-26: Performance archaeology: OLTP
• Tomas Vondra, Microsoft, 2024-12-03: Performance archaeology: OLAP
• Umair Shahid, Stormatics, 2024-12-10: Understanding Wait Events in PostgreSQL. See also: Wait Event Types.
  Caution: This feature seems to exist only in Redrock Postgres: Wait Events Overview
• Shane Borden, 2024-12-17: Some of My Favorite Things – Postgres Queries - Top SQL, Vacuum
• Bertrand Drouvot, 2025-01-06: Postgres backend statistics (Part 1): I/O statistics
• Jeremy Schneider, Ardent Performance Computing, 2025-01-08: Postgres Per-Connection Statistics
• Kaarel Moppel, 2025-01-22: Don’t forget about the Postgres parallel leader participation setting
• Hubert ‘depesz’ Lubaczewski, 2025-02-11: Waiting for PostgreSQL 18 – Add cost-based vacuum delay time to progress views.
• Semab Tariq, Stormatics, 2025-02-18: Important PostgreSQL Parameters: Understanding Their Importance and Recommended Values
• Ryan Booz, Redgate Software, 2025-03-10: Introducing pgNow: A free, point-in-time diagnostic tool for PostgreSQL
• Shayon Mukherjee, 2025-03-16: Selective asynchronous commits in PostgreSQL - balancing durability and performance
• Bertrand Drouvot, 2025-04-02: Postgres backend statistics (Part 2): WAL statistics
• Shiv Iyer, MinervaDB, 2025-04-03: PostgreSQL Temporary Data Performance Optimization
• Kaarel Moppel, 2025-04-24: Striping Postgres data volumes - a free lunch?
• Hubert ‘depesz’ Lubaczewski, 2025-05-05: Waiting for PostgreSQL 18 – Add function to get memory context stats for processes
• Jeremy Schneider, Ardent Performance Computing, 2025-07-04: Wait! What’s going on inside my database?
• Michael Christofides, pgMustard, 2025-08-07: “enable” parameters will work differently in Postgres 18
• Tomas Vondra, 2025-08-20: Fun and weirdness with SSDs
• Tomas Vondra, 2025-09-24: Tuning AIO in PostgreSQL 18
• David Christensen, Crunchy Data, 2025-10-17: Is Postgres Read Heavy or Write Heavy? (And Why You Should You Care)
• Mark Callaghan, 2023-03-16: Huge pages with Postgres & InnoDB: better perf, but a bit more work - hugetlbpage
• Paul Ramsey, Crunchy Data, 2025-10-20: PostGIS Performance: pg_stat_statements and Postgres tuning
• Hans-Jürgen Schönig, Cybertec, 2025-11-25: Super fast aggregations in PostgreSQL 19
• Josef Machytka, NetApp/Credativ, 2025-12-15: PostgreSQL 18 Asynchronous Disk I/O - Deep Dive Into Implementation
• Mayur, 2025-12-19: The OOM-Killer Summoning Ritual: “Just Increase work_mem”
• Mayur, 2025-12-23: PostgreSQL Santa’s Naughty Query List: How to Earn a Spot on the Nice Query List?
• Umair Shahid, Stormatics, 2025-12-23: PostgreSQL Column Limits - The 1,600‑column ceiling, and the real production problems that show up long before it
• Shiv Iyer, MinervaDB, 2025-12-27: Optimizing Pagination in PostgreSQL 17
• Hubert ‘depesz’ Lubaczewski, 2026-01-06: What is index overhead on writes?
• Dave Page, pgEdge, 2026-01-16: Introducing pgEdge Load Generator: Realistic PostgreSQL Workload Simulation
• Radim Marek, boringSQL, 2026-01-24: Introduction to Buffers in PostgreSQL
• Warda Bibi, Stormatics, 2026-01-29: Unlocking High-Performance PostgreSQL: Key Memory Optimizations
• Shane Borden, 2026-02-10: Do PostgreSQL Sub-Transactions Hurt Performance?
• Michael Christofides, 2026-02-13: Read efficiency issues in Postgres queries
• Radim Marek, boringSQL, 2026-02-19: Inside PostgreSQL’s 8KB Page
• Mark Callaghan, 2026-03-16: CPU efficiency for MariaDB, MySQL and Postgres on TPROC-C with a small server
• Hamza Sajawal, Stormatics, 2026-03-17: pgNow Instant PostgreSQL Performance Diagnostics in Minutes
• Shaun Thomas, pgEdge, 2026-03-27: Absorbing the Load - Materialized Views
• Richard Yen, 2026-04-13: Understanding PostgreSQL Wait Events
• Richard Yen, 2026-04-20: The Postgres Performance Triangle
• Radim Marek, boringSQL, 2026-06-02: pg_stat_statements: everything it tells you
• Radim Marek, boringSQL, 2026-06-03: pg_stat_statements: everything it can’t
• Warda Bibi, Stormatics, 2026-06-04: File Descriptors: The OS Limit That Takes Down PostgreSQL
• Nikolay Sivko, coroot, 2026-07-21: Let’s break autovacuum in Postgres: reproducing failures to make it observable
• Christophe Pettus, PGX, 2026-06-23: All Your GUCs in a Row: fsync
• Christophe Pettus, PGX, 2026-07-24: All Your GUCs in a Row: full_page_writes
• PGPerfFarm
• Liz van Dijk, PlanetScale, 2026-08-07: Concurrency vs. Throughput: why more parallelism can make databases slower
• Christophe Pettus, PGX, 2026-08-11: All Your GUCs in a Row: io_combine_limit and io_max_combine_limit
• Christophe Pettus, PGX, 2026-09-06: All Your GUCs in a Row: logical_decoding_work_mem
• Christophe Pettus, PGX, 2026-09-07: All Your GUCs in a Row: maintenance_io_concurrency
• Christophe Pettus, PGX, 2026-09-08: All Your GUCs in a Row: maintenance_work_mem

Planner, Optimizer, Statistics

• Hans-Jürgen Schönig, Cybertec, 2021-03: How the PostgreSQL query optimizer works
• Ryan Marcus, 2024-04-12: Ten years of improvements in PostgreSQL’s optimizer
• Semab Tariq, Stormatics, 2024-06-08: Performance impact of using ORDER BY with LIMIT in PostgreSQL
• Andrei Lepikhov, 2024-06-26: PostgreSQL Sort estimation instability
• Andrei Lepikhov and Alena Rybakina, 2024-07-01: Elaboration of the PostgreSQL sort cost model - Column order matters
• Andrei Lepikhov, 2024-07-29: Designing a Prototype: Postgres Plan Freezing - The story of one extension
• Deepak Mahto, 2024-08-02: Simplify PostgreSQL Execution Plan Analysis with StatsViaExplainAnalyze
• Andrei Lepikhov, 2024-08-12: Probing indexes to survive data skew in Postgres - An attempt to respond the data skew issue in Postgres planner
• Hubert ‘depesz’ Lubaczewski, 2024-12-11: Waiting for PostgreSQL 18 – Enable BUFFERS with EXPLAIN ANALYZE by default
• Andrei Lepikhov, 2025-01-18: Whose optimisation is better? - How to compare the quality of SQL query plans in PostgreSQL
• Hans-Jürgen Schönig, Cybertec, 2025-01-20: # GROUP BY: Fixing optimizer estimates
• Louise Leinweber Grandjonc on YouTube, Crunchy Data, 2024: A Deep Dive into Statistics
• Andrei Lepikhov, 2025-03-09: Automated Management of Extended Statistics in PostgreSQL - The history of one more Postgres extension development
• Tomas Vondra, 2025-06-30: How often is the query plan optimal?
• Andrei Lepikhov, 2025-07-03: On Postgres Plan Cache Mode Management - Can the generic plan switch method provide better performance guarantees?
• Tomas Vondra, 2025-07-08: So why don’t we pick the optimal query plan?
• Laurenz Albe, Cybertec, 2025-10-21: Benefits of a DESCending index
• Chao Li, High Go, 2025-10-22: Understanding the Execution Plan of a Hash Join
• Robins Tharakan, 2025-11-27: Settling COUNT(*) vs COUNT(1) debate in Postgres 19
• Robins Tharakan, 2025-11-29: Teaching Query Planner to See Inside C Functions
• Robins Tharakan, 2025-12-03: Speed up JOIN Planning - upto 16x Faster!
• Elizabeth Christensen, Crunchy Data, 2025-12-04: Postgres Scan Types in EXPLAIN Plans
• Robins Tharakan, 2025-12-09: 3x Faster TID Range Scans - Postgres 19
• Frédéric Yhuel, Dalibo, 2026-01-12: The strange case of the underestimated Merge Join node
• Andrei Lepikhov, 2026-01-28: 500 Milliseconds on Planning: How PostgreSQL Statistics Slowed Down a Query 20 Times Over - When legacy decisions meet current database realities
• Robins Tharakan, 2026-02-04: The “Skip Scan” You Already Had Before v18
• Radim Marek, boringSQL, 2026-02-06: Reading Buffer statistics in EXPLAIN output
• Shinya Kato, 2026-02-06: Reducing row count estimation errors in PostgreSQL
• Ahmed Gouda, Cybertec, 2026-02-10: Monitoring query plans with pgwatch and pg_stat_plans
• Radim Marek, boringSQL, 2026-03-09: Production query plans without production data
• Radim Marek, boringSQL, 2026-03-21: pg_regresql: truly portable PostgreSQL statistics
• Hubert ‘depesz’ Lubaczewski, 2026-03-22: Waiting for PostgreSQL 19 – Add pg_plan_advice contrib module
• Richard Yen, 2026-03-30: The Hidden Behavior of plan_cache_mode
• Richard Yen, 2026-03-23: EXPLAIN’s Other Superpowers
• Christophe Pettus, PGX, 2026-04-19: Hints, Part 1: The State of the Art Everywhere But Here
• Christophe Pettus, PGX, 2026-04-20: Hints, Part 2: Features We Do Not Want
• Christophe Pettus, PGX, 2026-04-21: Hints, Part 3: Advice, Not Orders
• Richard Yen, 2026-04-27: Understanding Bitmap Heap Scans in PostgreSQL
• Shaun Thomas, pgEdge, 2026-06-05: Looking Forward to Postgres 19: Query Hints
• Christophe Pettus, PGX, 2026-06-08: How the Other Half Counts
• Christophe Pettus, PGX, 2026-06-11: All Your GUCs in a Row: default_statistics_target
• Andrei Lepikhov, 2026-06-20: Optimising Polymorphic Associations in PostgreSQL - Help the planner avoid performance cliffs
• Christophe Pettus, PGX, 2026-06-22: All Your GUCs in a Row: enable_async_append
• Richard Yen, 2026-06-22: pg_stats: How Postgres Internal Stats Work
• Christophe Pettus, PGX, 2026-06-23: All Your GUCs in a Row: enable_indexscan and enable_bitmapscan
• Tomas Vondra, 2026-06-23: Some more thoughts on random_page_cost
• Christophe Pettus, PGX, 2026-07-22: All Your GUCs in a Row: from_collapse_limit
• Christophe Pettus, PGX, 2026-07-25: All Your GUCs in a Row: The geqo Family
• Christophe Pettus, PGX, 2026-07-28: All Your GUCs in a Row: hash_mem_multiplier
• Radim Marek, boringSQL, 2026-08-05: The DISTINCT in your COUNT
• Dimitri Fontaine, Neon, 2026-09-15: Plan Advice in PostgreSQL 19

Benchmarking

• Andrei Lepikhov, 2024-07-14: How expensive is it to maintain extended statistics? - Some post-benchmarking insights
• Jeremy Schneider, Ardent Performance Computing, 2024-08-18: Good Benchmark Engineers and Postgres Benchmark Week
• Michael Banck, Credativ / NetApp: 2024-09-03: Quick Benchmark: ANALYZE vs. maintenance_io_concurrency
• Laurenz Albe, Cybetec, 2025-01-27: commit_delay for better performance: a PostgreSQL benchmark
• Tomas Vondra, 2025-06-05: Benchmarking is hard, sometimes …
• Mark Callaghan, 2025-10-05: Measuring scaleup for Postgres 18.0 with sysbench - huge pages
• Ben Dicken, PlanetScale, 2025-10-14: Benchmarking Postgres 17 vs 18
• Mark Callaghan, 2025-11-29: Using sysbench to measure how Postgres performance changes over time, November 2025 edition
• Tomas Vondra, 2026-01-06: Stabilizing Benchmarks
• Mark Callaghan, 2026-01-14: Debugging regressions with Postgres in IO-bound sysbench
• Mark Callaghan, 2026-01-21: IO-bound Insert Benchmark vs MySQL on 24-core and 32-core servers
• Mark Callaghan, 2026-01-22: CPU-bound Insert Benchmark vs Postgres on 24-core and 32-core servers
• Mayur, 2026-07-07: My Dishonest Benchmark
• Avinash Vallarapu (CEO), HexaCluster, 2026-08-05: Tuning PostgreSQL HOT Updates - A HammerDB Benchmark

Training, Education

• Alisdair Owens: PostgreSQL Exercises
• PostgresPro: Блокировки - Блокировки в оперативной памяти
• PostgresPro: Журналирование - Буферный кеш
• Cornelia Biacsics, Cybertec, Microsoft, 2026-07-22: Building the OAPE PostgreSQL Certification
• Open Alliance for PostgreSQL Education
• PostgreSQL Open Certification: Level: DBA-1
• Dimitri Fontaine, Neon: The Art of PostgreSQL on GitHub

Development, Tools, GIS

• Christoph Schiessl, 2024-07-01: Using Transaction Chaining to Reduce Server Round-Trips
• Paul Ramsey, Crunchy Data, 2024-08-05: Six Degrees of Kevin Bacon - Postgres Style Graph
• Shaun M. Thomas, 2024-08-09: PG Phriday: My Postgres is Rusty Rust
• Deepak Mahto, 2024-08-31: Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 6: Login Event Trigger
• Elizabeth Christensen, Crunchy Data, 2024-09-17: Window Functions for Data Analysis with Postgres
• Florent Jardin, 2024-09-19: Hierarchical data types
• Adam Hendel, Tembo, 2024-09-24: Building an image search engine on Postgres
• Hubert ‘depesz’ Lubaczewski, 2024-10-11: SQL/JSON is here! (kinda “Waiting for Pg 17”)
• Paul Ramsey, Crunchy Data, 2024-10-11: Convert JSON into Columns and Rows with JSON_TABLE
• David E. Wheeler: pgenv - PostgreSQL binary manager
• Christophe Pettus, PGX, 2024-10-25: “Gentlemen, this is a 🏈”: Glyphs, Encodings, Collations, and Locales
• Christophe Pettus, PGX, 2024-10-27: Speaking in Tongues: PostgreSQL and Character Encodings
• Christopher Winslett, Crunchy Data, 2024-10-29: 4 Ways to Create Date Bins in Postgres: interval, date_trunc, extract, and to_char
• Shayon Mukherjee, 2024-10-29: Using CTID Based Pagination for Data Cleanups in PostgreSQL
• Christophe Pettus, PGX, 2024-10-30: An Interlude: Why you do not want to use C/POSIX locale
• Radim Marek, boringSQL, 2024-11-09: Text identifiers in PostgreSQL database design
• Elizabeth Christensen, Crunchy Data, 2024-11-18: Easy Totals and Subtotals in Postgres with Rollup and Cube
• Leo Hsu, Regina Obe, Postgres OnLine Journal, 2024-11-25: Some of my favorite PostgreSQLisms
• Hubert ‘depesz’ Lubaczewski, 2024-11-25: How can I send mail or HTTP request from database?
• Andrei Lepikhov, 2024-11-25: Could GROUP-BY clause reordering improve performance? - Utilising statistics to optimise GROUP-BY clause order
• Umair Shahid, Stormatics, 2024-11-27: Operator Classes: Fine-Tuning Index Performance in PostgreSQL
• Leo Hsu, Regina Obe, Postgres OnLine Journal, 2024-12-01: Substring function Regex style
• Keith Fiske, Crunchy Data, 2024-12-06: Postgres Partitioning with a Default Partition
• Stefanie Janine Stölting, ProOpenSource OÜ, 2024-12-09: Implementing Time Travel In PostgreSQL
• Hubert ‘depesz’ Lubaczewski, 2025-02-28: Waiting for PostgreSQL 18 – Virtual generated columns
• Michael Christofides, pgMustard, 2025-03-05: Postgres query plan visualization tools
• Hans-Jürgen Schönig, Cybertec, 2025-03: PostgreSQL: To normalize or not to normalize?
• Paul Ramsey, Crunchy Data, 2025-03-14: Pi Day PostGIS Circles
• Esther Minano Sanz, Xata, 2025-03-27: pgstream v0.4.0: Postgres-to-Postgres replication, snapshots & transformations - Learn how the latest features in pgstream refine Postgres replication with near real-time data capture, consistent snapshots, and column-level transformations.
• Pavel Stehule, 2025-03-29: How to fix Hibernate bug by conditional index
• Radim Marek, boringSQL, 2025-04-06: Time to Better Know The Time in PostgreSQL
• Umair Shahid, Stormatics, 2025-04-07: SELECT FOR UPDATE – Reduce Contention and Avoid Deadlocks to Improve Performance in PostgreSQL
• Laurenz Albe, Cybertec, 2025-06-17: SELECT FOR UPDATE considered harmful in PostgreSQL
• Dave Stokes, 2025-06-25: Entity Relationship Maps
• Practical Data Modeling
• Andrew Atkinson, 2025-07-02: Avoid UUID Version 4 Primary Keys
• Stefanie Janine Stölting, ProOpenSource, 2025-08-19: pgsql_tweaks is a bundle of functions and views for PostgreSQL
• Daniel Vérité, 2025-10-01: Pipelining in psql (PostgreSQL 18)
• Shane Borden, 2025-10-14: Understanding and Setting PostgreSQL JDBC Fetch Size
• Hubert ‘depesz’ Lubaczewski, 2025-11-29: Using JSON: json vs. jsonb, pglz vs. lz4, key optimization, parsing speed?
• Laurenz Albe, Cybertec, 2025-12-02: What is better: a lookup table or an enum type?
• Gulcin Yildirim Jelinek, Xata, 2025-12-10: What you should know about constraints in PostgreSQL
• Dave Page, pgEdge, 2025-12-15: Anonymising PII in PostgreSQL with pgEdge Anonymizer
• Taras Kloba, 2025-12-27: PostgreSQL as a Graph Database: Who Grabbed a Beer Together?
• Hubert ‘depesz’ Lubaczewski, 2026-01-06: Small improvement for pretty-printing in paste.depesz.com
• Radim Marek, boringSQL, 2026-01-12: The hidden cost of PostgreSQL arrays
• Esther Minano Sanz, Xata, 2026-01-12: Optimizing data throughput for Postgres snapshots with batch size auto-tuning
• Laurenz Albe, Cybertec, 2026-01-13: Dealing with integer overflow in sequence-generated primary keys
• Federico Razzoli Vettabase, 2026-01-19: Distributed, Multi-Database Transactions Involving MariaDB and PostgreSQL
• Elizabeth Christensen, Crunchy Data, 2026-01-20: Postgres Serials Should be BIGINT (and How to Migrate)
• Umair Shahid, Stormatic, 2026-02-03: PostgreSQL Materialized Views: When Caching Your Query Results Makes Sense (And When It Doesn’t)
• Hubert ‘depesz’ Lubaczewski, 2026-01-27: How to render timestamp with a timezone that is different from current?
• Vibhor Kumar, EDB, 2026-02-16: pg_background: make Postgres do the long work (while your session stays light)
• Jobin Augustine: pg_gather aka pgGather
• Radim Marek, boringSQL, 2026-03-29: Good CTE, bad CTE
• Hubert ‘depesz’ Lubaczewski, 2026-03-29: Waiting for PostgreSQL 19 – json format for COPY TO
• Vibhor Kumar, EDB, 2026-04-01: pg_background v1.9: a calmer, more practical way to run SQL in the background
• Vibhor Kumar, EDB, 2026-06-08: pg_background 2.0: Run SQL in the Background, Now Cleaner, Safer, and Ready for PostgreSQL 19
• Gulcin Yildirim Jelinek, Xata, 2026-06-30: PostgreSQL as a temporal database
• Haki Benita, 2026-07-09: How to Achieve Pruning When Querying by Non-Partitioned Columns in PostgreSQL
• Radim Marek, boringSQL, 2026-07-12: The tests passed. The plan didn’t
• Hans-Jürgen Schönig, Cybertec, 2026-07-14: How SQL/PGQ Rewrites to Joins on PostgreSQL 19
• Christophe Pettus, PGX, 2026-07-15: All Your GUCs in a Row: event_triggers
• Jimmy Angelakos, 2026-07-15: LISTEN Carefully: How NOTIFY Can Trip Up Your Database
• Christopher Winslett, Crunchy Data, 2026-07-30: Hybrid Search Patterns with Postgres and pgvector
• Dimitri Fontaine, Neon, 2026-08-11: Introducing sqlfmt: an SQL gofmt-style formatter
  • PostgreSQL SQL Formatter
• Command Prompt, Inc: 2026-08-12: plx : Write PostgreSQL functions in the language you already know
• Ronald Bradford, 2026-08-15: What Constitutes Clean Data?
• Ronald Bradford, 2026-08-16: Why INSERT IGNORE should not be used - GIS
• Ronald Bradford, 2026-08-17: Curating DuckDB Datasets Leveraging AI
• Andrew Atkinson, 2026-08-26: PostgreSQL 18: 23x Faster Inserts With UUID v7
• Radim Marek, boringSQL, 2026-08-31: Read your own writes, off the primary
• Christopher Winslett, 2026-09-02: Postgres Calculations and the Ambiguity of NULL
• Andrei Lepikhov, pgEdge, 2026-09-03: Why is numeric so popular in PostgreSQL databases?
• Christophe Pettus, PGX, 2026-09-13: All Your GUCs in a Row: max_identifier_length
• Christophe Pettus, PGX, 2026-09-12: All Your GUCs in a Row: max_function_args
• Radim Marek, boringSQL, 2026-09-11: The unbearable lightness of one more index
• Mikhail Shytsko, Seedfast: 2026-09-11: Your Agent Can Turn Off Its Own Kill Switch
• Andrei Lepikhov, pgEdge, 2026-09-10: Optimising PostgreSQL Aggregates: What Can an Extension Do?
• Federico Razzoli, Vettabase, 2026-09-14: Optimising Multi-Range Queries with Logical Charts
• Christophe Pettus, PGX, 2026-09-01: SQL/PGQ in PostgreSQL 19: Graph Queries Without the Graph Database
• Christophe Pettus, PGX, 2026-09-17: All Your GUCs in a Row: max_notify_queue_pages
• 2026-09-22: PostgresCompare 2.2.0 Released
• Christophe Pettus, PGX, 2026-09-23: All Your GUCs in a Row: max_prepared_transactions

Artificial Intelligence, AI, RAG, LLM, MCP

See also: Development, Tools, Artificial Intelligence

• Jonathan Katz, 2024-09-16: Hybrid search with PostgreSQL and pgvector
• Shaun Thomas, EDB, 2024-12-13: PG Phriday: Whats Our Vector Victor
• Shaun Thomas, pgEdge, 2025-10-15: What’s Our Vector, Victor? Building AI Apps with Postgres
• Adrien Obernesser, DBI services, 2025-10-26: RAG Series – Agentic RAG
• Dave Page, pgEdge, 2025-12-04: Building a RAG Server with PostgreSQL - Part 1: Loading Your Content
• Dave Page, pgEdge, 2025-12-09: Building a RAG Server with PostgreSQL - Part 2: Chunking and Embeddings
• Dave Page, pgEdge, 2025-12-19: RAG Servers vs MCP Servers: Choosing the Right Approach for AI-Powered Database Access
• Antony Pegg, pgEdge, 2026-01-29: How to Use the pgEdge MCP Server for PostgreSQL with Claude Cowork
• Richard Yen, 2026-03-16: Learning AI Fast with pgEdge’s RAG
• Ryan Lambert, 2026-03-18: Local LLM with OpenWeb UI and Ollama
• Ahsan Hadi, pgEdge, 2026-04-07: Using the pgEdge MCP Server with a Distributed PostgreSQL Cluster
• Antony Pegg, pgEdge, 2026-04-02: pgEdge MCP Server for Postgres Is Now GA. Here’s Why That Matters
• Ahsan Hadi, pgEdge, 2026-04-15: pgEdge Vectorizer and RAG Server: Bringing Semantic Search to PostgreSQL (Part 2)
• Viktoriia Hrechukha, 2026-07: Embedding Workloads as a New Stress Test for Postgres
• Ahsan Hadi, pgEdge, 2026-07-22: Hybrid Search in PostgreSQL: BM25, Sparse Vectors, and Reciprocal Rank Fusion
• Christophe Pettus, PGX, 2026-08-05: Ontogeny Recapitulates the Relcache
• Wellingtone Luvonga, Cybertec, 2026-08-05: Mastering PostgreSQL Configuration Management with CloudNativePG (CNPG)