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

Introduction  Performance optimization is one of the most common challenges faced by organizations running business-critical workloads on Azure Database for PostgreSQL flexible server. As your work...