Interesting PostgreSQL Blog Articles

/ home / computer / postgresql / .

Table of Contents

• General
• Internals
• Architecture, Design, Topologies, High Availability
• Operations
  • Backup, Restore, Recovery
  • Security
  • Migration
• Performance, Optimizer, Query tuning, Statistics, Benchmarking
• Training, Education
• Development, Tools, Artificial Intelligence
  • Artificial Intelligence
• Business

General

• 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?

Internals

• 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
• Peter Eisentraut, EnterpriseDB, 2024-11-26: Why PostgreSQL major version upgrades are hard
• 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
• Ants Aasma, Cybertec, 2025-02-18: End of the road for PostgreSQL streaming replication?
• 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
• Andrei Lepikhov, 2025-10-18: Revising the Postgres Multi-master Concept - Does logical replication have hidden potential?
• 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)
• Andrew Dunstan, EnterpriseDB, 2025-12-12: How does the PostgreSQL Buildfarm check upgrades across versions?
• 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

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
• Semab Tariq, Stormatics, 2024-05-17: Understanding Synchronous and Asynchronous Replication in PostgreSQL – What is Best for You?
• 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
• Shayon Mukherjee, 2024-07-13: Use pg_easy_replicate for setting up Logical Replication and Switchover in PostgreSQL
• Paul Laurence, 2024-07-24: Unleashing Postgres for Analytics With DuckDB Integration
• Hayato Kuroda, Fujitsu, 2024-08-22: New logical replication features in PostgreSQL 17
• 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
• Shayon Mukherjee, 2024-08-31: pg_easy_replicate Supports Schema Change Tracking During Logical Replication
• 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
• PostGIS: Getting Started
• Jonathan Katz, 2024-09-16: Hybrid search with PostgreSQL and pgvector
• 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
• Semab Tariq, Stormatics, 2024-10-17: Implementing Bi-Directional Replication in PostgreSQL
• 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
• Kaarel Moppel, 2024-12-09: Postgres Synchronous Replication - a 99.99% guarantee only
• Shaun Thomas, EDB, 2024-12-13: PG Phriday: Whats Our Vector Victor
• 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
• Ahsan Hadi, pgEdge, 2025-01-27: Preserving replication slots across major Postgres versions - PostgreSQL high availability for major upgrades
• Avinash Vallarapu, HexaCluster, 2025-03-06: Streaming Replication Internals for High Availability in PostgreSQL
• 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
• Ahsan Hadi, pgEdge, 2025-05-07: Unleashing the Power of PostgreSQL with pgEdge Distributed Multi-Master Replication and Postgres Platform - Part 1
• Karen Jex, 2025-06-02: Postgres Partitioning Best Practices
• Ashutosh Bapat, 2025-06-06: Avoiding disk spills due to PostgreSQL’s logical replication
• Jan Wieremjewicz, Percona, 2025-06-18: PostgreSQL active-active replication, do you really need it? - pgactive
• 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?
• Christophe Pettus, PostgreSQL Experts, Nordic PGDay 2023: Real-World Logical Replication
• 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
• Semab Tariq, Stormatics, 2025-07-10: Replication Types and Modes in PostgreSQL
• Jan Wieremjewicz, Percona, 2025-07-10: Active-active replication - the hidden costs and complexities
• 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
• 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
• 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
• Stefan Fercot, 2025-11-17: pgBackRest TLS server mode for a primary-standby setup with a repository host
• 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.
• 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
• Luca Ferrari, 2026-01-31: pgagroal 2.0.0 is available! - connection pooler
• Avinash Vallarapu, Gilles Darold, HexaCluster, 2026-01-30: Send Emails like Oracle UTL_SMTP using pg_utl_smtp for PostgreSQL
• Lætitia Avrot, 2026-01-28: Why Your HA Architecture is a Lie (And That’s Okay)
• 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
• Zongzhi Chen, 2026-02-05: Why MySQL’s Integration with DuckDB is More Elegant Than PostgreSQL’s

Operations

• Laurenz Albe, Cybetec, 2021-02: Estimating connection pool size with PostgreSQL database statistics
• Paolo Melchiorre, 2024-05-20: Upgrade PostgreSQL from 15 to 16 on Ubuntu 24.04
• 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
• Andrew Atkinson, 2024-07-23: Wait a minute! — PostgreSQL extension pg_wait_sampling
• Tomas Vondra, EnterpriseDB, 2024-07-15: Autovacuum Tuning Basics
• Carlos Pérez-Aradros Herce, Xata, 2024-07-18: Postgres major version upgrades with minimal downtime
• 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
• Stefan Fercot, Data Egret, 2024-09-05: PITR and Streaming Replication environments
• Andrew Atkinson, 2024-09-06: Shrinking Big PostgreSQL tables: Copy-Swap-Drop
• 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
• 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
• Shaun Thomas, Tembo, 2024-11-05: Plugging the Postgres Upgrade Hole
• 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, PostgreSQL Experts, 2024-11-15: The Doom That Came To PostgreSQL: When Collations Change
• Christophe Pettus, PostgreSQL Experts, 2024-11-20: Talk Fast: The Speed of Various Collations
• Christophe Pettus, PostgreSQL Experts, 2024-11-22: Locale Cooking: Common Scenarios and Suggestions
• Gabriele Bartolini, EnterpriseDB, 2024-12-11: CNPG Recipe 15 - PostgreSQL major online upgrades with logical replication - Unleashing the Power of Postgres in Kubernetes
• Andrei Lepikhov, 2024-12-15: Fractional Path Issue in Partitioned Postgres databases - Continuing discovery on Postgres planner weak points
• Umair Shahid, Stormatics, 2024-12-13: VACUUM FULL in PostgreSQL – What you need to be mindful of
• Hubert ‘depesz’ Lubaczewski, 2024-12-12: How to ALTER tables without breaking application?
• Shane Borden, 2024-12-17: Some of My Favorite Things – Postgres Queries - Top SQL, Vacuum
• 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?
• Hubert ‘depesz’ Lubaczewski, 2025-01-06: Waiting for PostgreSQL 18 – Allow changing autovacuum_max_workers without restarting
• Christophe Pettus, PostgreSQL Experts, 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
• Greg Sabino Mullane, Crunchy Data, 2025-03-19: Postgres Troubleshooting: Fixing Duplicate Primary Key Rows
• Gabriele Bartolini, EnterpriseDB, 2025-04-03: CNPG Recipe 17 - PostgreSQL In-Place Major Upgrades
• 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
• Paolo Melchiorre, 2025-05-07: Upgrade PostgreSQL from 16 to 17 on Ubuntu 25.04
• Tianzhou, 2025-05-23: What’s New in PostgreSQL 18 - a DBA’s Perspective
• Shiv Iyer, MinervaDB, 2025-06-03: PostgreSQL 18 IOPS Optimization
• Shiv Iyer, MinervaDB, 2025-06-11: Troubleshooting PostgreSQL Page Corruption
• 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?
• Radim Marek, boringSQL, 2025-06-11: First steps with Logical Replication in PostgreSQL
• Laurenz Albe, Cybertec, 2025-06-17: Preserve optimizer statistics during major upgrades with PostgreSQL v18
• Radim Marek, boringSQL, 2025-06-24: Beyond the Basics of Logical Replication
• Shiv Iyer, MinervaDB, 2025-06-27: PostgreSQL Threat Modeling for FinTech
• Shiv Iyer, MinervaDB, 2025-08-05: Mastering PostgreSQL Replication: A Complete Guide for Database Professionals
• Elizabeth Christensen, Crunchy Data, 2025-08-19: Postgres Logging for Performance Optimization
• Laurenz Albe, Cybertec, 2025-08-12: Should I rebuild my PostgreSQL index?
• 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.
• Javier Jaramago Fernandez, ProxySQL, 2025-08-29: PostgreSQL Monitoring with ProxySQL
• 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
• Greg Sabino Mullane, Crunchy Data, 2025-12-11: Postgres 18 New Default for Data Checksums and How to Deal with Upgrades
• Stefan Fercot, Data Egret, 2025-12-11: pgBackRest PITR in Docker: a simple demo
• Antony Pegg, pgEdge, 2025-12-12: Zero-Downtime PostgreSQL Maintenance with pgEdge
• Laurenz Albe, Cybertec, 2025-12-16: Which indexes can be corrupted after an operating system upgrade?
• 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)
• Umut Tekin, Cybertec, 2026-01-06: Exploration: CNPG Logical Replication in PostgreSQL
• Deepak Mahto, 2026-01-05: PostgreSQL Table Rename and Views – An OID Story
• Hubert ‘depesz’ Lubaczewski, 2026-01-07: Quick and dirty loading of CSV files
• Josef Machytka, Creadativ, 2026-01-06: Dissecting PostgreSQL Data Corruption
• 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
• Jobin Augustine, Percona, 2026-02-02: Importance of Tuning Checkpoint in PostgreSQL
• Semab Tariq, Stormatics, 2026-01-27: Unused Indexes In PostgreSQL: Risks, Detection, And Safe Removal

Backup, Restore, Recovery

• 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
• 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, 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

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, PostgreSQL Experts, 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!

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
• 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_dumpbinary, 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

Performance, Optimizer, Query tuning, Statistics, Benchmarking

• Hans-Jürgen Schönig, Cybertec, 2021-03: How the PostgreSQL query optimizer works
• Deepak Mahto, 2024-05-23: Optimizing Performance in PostgreSQL: Join Column and ANY Filters
• Semab Tariq, Stormatics, 2024-06-08: Performance impact of using ORDER BY with LIMIT in PostgreSQL
• Hubert ‘depesz’ Lubaczewski, 2024-06-11: How much speed you’re leaving at the table if you use default locale? Character set, collation, locale
• 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
• Semab Tariq, Stormatics, 2024-07-03: Key PostgreSQL Configuration Parameters for Enhanced Performance
• Andrei Lepikhov, 2024-07-14: How expensive is it to maintain extended statistics? - Some post-benchmarking insights
• Semab Tariq, Stormatics, 2024-07-22: A Follow up on Key PostgreSQL Configuration Parameters for Enhanced Performance – Part 2
• 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
• Grant Fritchey, ScaryDBA, 2024-08-05: PostgreSQL and Instrumentation
• Andrei Lepikhov, 2024-08-12: Probing indexes to survive data skew in Postgres - An attempt to respond the data skew issue in Postgres planner
• Jeremy Schneider, Ardent Performance Computing, 2024-08-18: Good Benchmark Engineers and Postgres Benchmark Week
• Deepak Mahto, 2024-08-27: Exploring PostgreSQL 17: A Developer’s Guide – Part 5 : Correlated IN Clause Transformation
• Michael Banck, Credativ / NetApp: 2024-09-03: Quick Benchmark: ANALYZE vs. maintenance_io_concurrency
• 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
• Hubert ‘depesz’ Lubaczewski, 2024-12-11: Waiting for PostgreSQL 18 – Enable BUFFERS with EXPLAIN ANALYZE by default
• 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
• 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
• Kaarel Moppel, 2025-01-22: Don’t forget about the Postgres parallel leader participation setting
• Laurenz Albe, Cybetec, 2025-01-27: commit_delay for better performance: a PostgreSQL benchmark
• Grant Fritchey, Redgate Software, 2025-02-13: Free PostgreSQL Performance Monitoring with pgNow
• 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
• 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
• 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
• Tomas Vondra, 2025-06-05: Benchmarking is hard, sometimes …
• 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?
• 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
• Ben Dicken, PlanetScale, 2025-10-14: Benchmarking Postgres 17 vs 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
• Mark Callaghan, 2025-10-05: Measuring scaleup for Postgres 18.0 with sysbench - huge pages
• Laurenz Albe, Cybertec, 2025-10-21: Benefits of a DESCending index
• Paul Ramsey, Crunchy Data, 2025-10-20: PostGIS Performance: pg_stat_statements and Postgres tuning
• Chao Li, High Go, 2025-10-22: Understanding the Execution Plan of a Hash Join
• Hans-Jürgen Schönig, Cybertec, 2025-11-25: Super fast aggregations in PostgreSQL 19
• Robins Tharakan, 2025-11-27: Settling COUNT(*) vs COUNT(1) debate in Postgres 19
• Mark Callaghan, 2025-11-29: Using sysbench to measure how Postgres performance changes over time, November 2025 edition
• 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
• https://www.thatguyfromdelhi.com/2025/12/3x-faster-tid-range-scans-postgres-19.html
• 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?
• Tomas Vondra, 2026-01-06: Stabilizing Benchmarks
• Mark Callaghan, 2025-01-14: Debugging regressions with Postgres in IO-bound sysbench
• Dave Page, pgEdge, 2026-01-16: Introducing pgEdge Load Generator: Realistic PostgreSQL Workload Simulation
• Frédéric Yhuel, Dalibo, 2026-01-12: The strange case of the underestimated Merge Join node
• 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
• Radim Marek, boringSQL, 2026-01-24: Introduction to Buffers in PostgreSQL
• Warda Bibi, Stormatics, 2026-01-29: Unlocking High-Performance PostgreSQL: Key Memory Optimizations
• 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
• Shinya Kato, 2026-02-06: Reducing row count estimation errors in PostgreSQL
• 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
• Shane Borden, 2026-02-10: Do PostgreSQL Sub-Transactions Hurt Performance?

Training, Education

• Alisdair Owens: PostgreSQL Exercises

Development, Tools, Artificial Intelligence

• 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, PostgreSQL Experts, 2024-10-25: “Gentlemen, this is a 🏈”: Glyphs, Encodings, Collations, and Locales
• Christophe Pettus, PostgreSQL Experts, 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, PostgreSQL Experts, 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?

Artificial Intelligence, AI, RAG, LLM, MCP

See also: Development, Tools, Artificial Intelligence

• 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

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