Introduction Bloat refers to the excess, wasted disk space occupied by "dead rows" (tuples) within tables and indexes that no longer hold active data. ​  ​This occurs because PostgreSQL uses Mult...

PostgreSQL 18 makes EXPLAIN more useful for real-world performance troubleshooting by exposing more of what happens during query execution. Beyond plan shape and execution time, it provides better vi...

Microsoft Ignite returns to San Francisco and online from November 17 to 20, 2026, and PostgreSQL is all over the agenda. Postgres has become the database of choice for modern application development...

Same Query, Same Index, Different Performance I recently worked with a customer planning a migration from on-premises PostgreSQL to Azure Database for PostgreSQL. During performance testing, they n...

Introduction   PostgreSQL is a robust and highly scalable database system, but as applications grow in size and complexity, performance challenges can begin to emerge. Slow queries, high resource c...

Last week at PGConf.EU in Valencia, I gave a talk about the Postgres work being done at Microsoft (slides here). Getting ready for that talk, I kept noticing how much has changed in the Postgres team...

This blog was authored by Sven Hubert, Associate Director IT Operations at Wolters Kluwer, Oliver Heimlich, Lead Product Software Engineer at Wolters Kluwer, Volker Krebs, DevOps Engineer at Wolters ...

By: Maxim Lukiyanov, PhD, Principal Software Engineer Every feature in PostgreSQL has a story. Before a line of code lands, it's proposed, debated, reviewed and often rewritten on the pgsql-hackers...

Understanding WAL in PostgreSQL  PostgreSQL uses Write-Ahead Logging (WAL) to guarantee durability and consistency. Every change made to the database is first recorded in WAL before being written ...