Blog Post

Microsoft Blog for PostgreSQL
4 MIN READ

PostgreSQL 19 on day one: new capabilities, a managed path forward

varun-dhawan's avatar
varun-dhawan
Icon for Microsoft rankMicrosoft
Nov 19, 2026

Upgrade your engine, use familiar extensions, and build on the Azure platform you trust.

Innovation should not mean starting over

For enterprise teams, each PostgreSQL release brings an important opportunity: take advantage of new engine capabilities without adding unnecessary risk or disruption to production operations.

Adopting a new PostgreSQL version takes more than access to new engine capabilities. Teams need a practical way to evaluate it, an upgrade path for existing workloads, and confidence that the extensions their applications depend on are ready too.

Azure Database for PostgreSQL brings these pieces together for PostgreSQL 19 on day one. PostgreSQL 19 is available in Preview starting Nov 19, 2026 on Azure Database for PostgreSQL flexible server alongside its upstream release, with major version upgrade (MVU) and key extensions supported from day one.

Figure 1: PostgreSQL 19 Preview overview: day-one availability, in-place major version upgrade, and key extensions, with Preview in East Asia

A day-one path for existing servers

New deployments can explore PostgreSQL 19 as soon as it arrives. Existing deployments also have a path to move forward: major version upgrade supports PostgreSQL 19 on day one for eligible flexible server instances.

That gives teams a way to evaluate the new version and plan an upgrade within the managed service, rather than treating adoption as a separate migration project. As with any major version change, test with representative workloads before upgrading production.

Plan ahead: Validate before you upgrade. Pre-upgrade validation checks (PVC) now support PostgreSQL 19 as a target. Run them before upgrading to catch compatibility issues and upgrade blockers early. Resolve any issues ahead of your maintenance window; major version upgrades require downtime.

📖 Learn how to run pre-upgrade validation checks

Familiar extensions, ready for PostgreSQL 19

An engine upgrade is only useful when the application stack is ready for it. PostgreSQL 19 Preview includes support for key extensions on day one, helping teams evaluate the new engine alongside important parts of their existing PostgreSQL environment.

Check the current extension documentation for the supported names, versions, and configuration requirements as you plan your evaluation.

PostgreSQL 19: practical improvements across the engine

PostgreSQL 19 brings improvements across maintenance, query planning, and replication. Together, they give database teams more ways to manage routine work, understand planner behavior, and build applications that use replicas.

Figure 2: PostgreSQL 19 improvements across performance, efficiency, maintenance, and query planning

Here are three PostgreSQL 19 improvements worth highlighting:

More options for routine maintenance

Parallel autovacuum can process table indexes using parallel workers, while a new prioritization system helps direct maintenance toward tables that need it. The new REPACK command also provides a built-in way to reorganize tables; its CONCURRENTLY option allows reads and writes to continue during the operation.

More control over query plans

The pg_plan_advice extension lets teams provide guidance to the query planner, while pg_stash_advice can apply stored advice based on query identifiers. These capabilities give teams additional tools when investigating or managing plan behavior.

More efficient data loading and processing

PostgreSQL 19 improves foreign-key checks and accelerates delimiter scanning for text and CSV imports through COPY FROM using SIMD instructions. These engine-level optimizations help reduce processing overhead for data ingestion and everyday transactional workloads—while retaining the relational integrity applications depend on.

📖 For the complete list of changes, explore the PostgreSQL 19 release notes

📖 Review the server parameters available for PostgreSQL 19

Microsoft’s investment in open-source PostgreSQL 19

Figure 3: Microsoft’s contributions to PostgreSQL 19: 530 commits authored or co-authored and 1,084 commit reviews

Day-one availability is one part of the story. Microsoft also invests directly in the open-source PostgreSQL engine. The contribution snapshot shared at Microsoft Ignite 2026 highlights 530 PostgreSQL 19 commits authored or co-authored by Microsoft contributors and 1,084 reviews of PostgreSQL 19 commits. This work is a collaboration with the global PostgreSQL community, benefiting users wherever they run Postgres.

That investment includes several improvements featured here, from faster foreign-key checks and SIMD-accelerated COPY FROM parsing to reduced vacuum WAL generation. For Azure customers, it connects upstream engineering expertise with a managed path to adopting the latest PostgreSQL capabilities. For the broader story, read the article What’s new with Postgres at Microsoft, 2026 edition by Claire Giordano (clairegiordano​), which explores Microsoft’s contributions to PostgreSQL core and its wider investment in the Postgres ecosystem.

Preview availability starts in East Asia

PostgreSQL 19 Preview on Azure Database for PostgreSQL is available in East Asia, with more regions coming soon. Use the Preview to evaluate application compatibility, test the major version upgrade path, and validate extension requirements ahead of broader availability.

Start planning for PostgreSQL 19

With day-one availability, major version upgrade, and key extensions together, Azure Database for PostgreSQL gives teams a managed way to begin evaluating PostgreSQL 19 on arrival. Explore the new engine, understand how it fits your workloads, and prepare your upgrade plans with your application and operational needs in mind.

Updated Nov 19, 2026
Version 1.0
No CommentsBe the first to comment