Interesting PostgreSQL Blog Articles

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)

Andreas ‘ads’ Scherbaum, 2024-06-14: PostgreSQL Development Conference 2024 - Review

pgPedia

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

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

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 https://stormatics.tech/alis-planet-postgresql/vacuum-in-postgresql

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

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, 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: Setting-up a high availability-3-node-postgresql-cluster-with-patroni-on Ubuntu 24.04 https://github.com/zalando/patroni

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

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 https://github.com/CrunchyData/pgCompare

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

Gulcin Yildirim Jelinek, Xata, 2024-08-23: If pg_dump is not a backup tool, what is? - pg_dump was a utility for backing up a PostgreSQL database, not anymore

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

Florent Jardin, 2024-05-28: An assistant to copy data from a remote server

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

Alisdair Owens: PostgreSQL Exercises

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