When migrating databases to PostgreSQL, not all data transitions happen immediately. Applications often need to keep accessing legacy databases for reading or writing, whether during a phased migrati...

Azure customers can select newer compute options and scale resources in real time with minimal disruption to business operations. This flexibility allows you to scale capacity as demand changes, matc...

Why this topic? Transaction wraparound is one of the most critical PostgreSQL issues because it can eventually cause the database to stop accepting write operations. Azure PostgreSQL flexible serve...

Why DELETE Does Not Immediately Shrink Storage and Azure Monitor Storage Graphs Continue to Show High Storage Consumption PostgreSQL uses Multi-Version Concurrency Control, commonly called MVCC. MV...

The PostgreSQL project turned 30 years old in July.  As it enters middle-age, developers and builders rely on it more today than ever.  In the crowded and competitive SQL database market, what is dri...

Features PgBouncer: Update to 𝘃𝗲𝗿𝘀𝗶𝗼𝗻 𝟭.𝟮𝟱.𝟮 Azure Database for PostgreSQL Flexible Server now supports PgBouncer 1.25.2, keeping the built-in connection pooler aligned with the la...

This article explores the possibilities opened by the schema conversion workflow. It is an early evaluation: I used HorizonDB as a target, which is in preview and not a supported target yet, and Orac...

The PostgreSQL extension for Visual Studio Code now includes a Get Started landing page that helps you discover key features, access helpful resources, and become productive faster after connecting t...

By AI Omar Rajawat, Pranay Lohia, Gautam Juneja, Vikas Nimmagadda, Anil Dogra, Aditya Duvuri  We’re seeing significant interest in migrating database workloads from Oracle to Azure Database for Pos...

By Varun Dhawan, Ilan Benschikovski, and Alexander Kukushkin - Azure PostgreSQL, Microsoft Faster, Safer Upgrades for Databases with Large Objects TL;DR: We improved major version upgrades fo...