PostgreSQL continues to solidify its place as a top-tier database selection amongst workloads operating on Kubernetes.
Within the ever-evolving world of cloud-native applied sciences, PostgreSQL continues to solidify its place as a top-tier database selection amongst workloads operating on Kubernetes. In response to the Kubernetes within the Wild 2025 report, PostgreSQL now powers 36% of all database workloads operating on Kubernetes—up 6 factors since 2022—signaling its rising recognition and rising belief among the many Kubernetes group1. Nonetheless, operating data-intensive PostgreSQL workloads on Kubernetes has its personal set of challenges. These embrace managing Kubernetes primitives like StatefulSets and deployments, in addition to attaining optimum efficiency by configuring storage, replication, and database settings, however that is quick evolving to a simplified expertise.
We now present two choices for deploying stateful PostgreSQL workloads primarily based on efficiency wants. To help databases with stringent latency and scalable transaction necessities, you’ll be able to leverage Azure Container Storage to orchestrate Kubernetes quantity deployment on native NVMe to scale up IOPS whereas sustaining extraordinarily low sub-ms latency. For eventualities the place optimized price-performance is a precedence, Premium SSD v2 is the go-to selection. Moreover, working with CloudNativePG, we built-in a strong open-source operator for PostgreSQL to help a excessive availability database deployment mannequin on Azure Kubernetes Service (AKS). Our superior storage choices mixed with CloudNativePG make AKS a strong platform for high-performance PostgreSQL workloads.
Breakthrough PostgreSQL efficiency with native NVMe
For performance-critical PostgreSQL workloads, corresponding to these dealing with large concurrent transactions or demanding, low-latency knowledge entry, native NVMe immediately hooked up to Azure Digital Machine (VM) SKUs is your greatest wager. Utilizing native NVMe drives with Kubernetes was difficult—it typically required organising RAID throughout the drives and manually managing static quantity orchestrators. Azure Container Storage successfully addresses this problem.
Azure Container Storage is a totally managed, container-native storage answer, designed particularly for Kubernetes. Builders can merely request a Kubernetes quantity, and Azure will dynamically provision storage backed by the accessible native NVMe drives on AKS nodes. This provides PostgreSQL customers direct connect block storage IOPS and latency inside a managed, orchestrated cloud atmosphere. Whether or not you’re powering fee techniques, gaming backends, or real-time personalization engines, you get the perfect of each pace and ease. Azure Container Storage additionally helps Azure Disk and Elastic SAN (Preview), so you’ll be able to select backing storage with totally different sturdiness, scale, or price as your wants evolve—all beneath a constant, Kubernetes-native management airplane.
Our benchmark outcomes have proven PostgreSQL attaining shut to fifteen,000 transactions per second (TPS) with single-digit millisecond end-to-end question latency with the Standard_L16s_v3 VM. When scaling as much as bigger VM SKUs like Standard_L64s_v3, we noticed TPS reaching as much as 26,000 whereas sustaining low latency. For extra particulars of our benchmark runs, seek advice from the comparability of storage choices part beneath.
Optimize price-performance with Premium SSD v2
Azure Premium SSD v2 presents an optimum steadiness of price-performance and a versatile deployment mannequin, making it particularly well-suited for manufacturing environments that must scale over time. With Premium SSD v2, you’ll be able to configure IOPS, throughput, and dimension independently—enabling PostgreSQL deployments to scale dynamically with demand whereas minimizing upfront prices and avoiding useful resource overprovisioning.
Whether or not you’re operating multi-tenant SaaS platforms, manufacturing techniques that scale with enterprise wants, or functions with spiky site visitors, this flexibility results in actual financial savings with out sacrificing efficiency. With as much as 80,000 IOPS and 1,200 MB/s per quantity, Premium SSD v2 helps extremely demanding PostgreSQL workloads on an infrastructure that adapts to your app.
Comparability of storage choices
That will help you assess the 2 storage choices outlined above, we carried out benchmark runs utilizing the CloudNativePG operator setups on AKS with related core and reminiscence consumption, with each backing storage choices as the one variable: one leveraging native NVMe with Azure Container Storage, and the opposite utilizing Premium SSD v2 with Disk CSI driver.
For the primary configuration, we used Standard_D16d_v5 SKU and provisioned two Premium SSD v2 32 GiB disks every having 3000 IOPS and 125 MB/s throughput for log and knowledge recordsdata. Within the second setup, we ran on Standard_L16s_v3 nodes with native NVMe storage included. The check atmosphere was configured to intently simulate a real-world manufacturing database situation. TPS measures what number of particular person transactions (corresponding to INSERT, UPDATE, DELETE, or SELECT) a system can deal with per second. Latency refers back to the time delay between issuing a request to the database and receiving a response, which is particularly essential for functions requiring real-time or near-real-time responsiveness, corresponding to monetary techniques, on-line gaming, or high-performance analytics.
Native NVMe on Standard_L16s_v3 delivered 14,812 TPS with an common latency of 4.321 milliseconds. PremiumV2_LRS on Standard_D16ds_v5 recorded 8,600 TPS at 7.417 milliseconds latency. See pricing comparability beneath:
*Month-to-month prices are primarily based on the bottom 3000 IOPS and 125 MB/s throughput. You possibly can alter the efficiency (capability, throughput, and IOPS) of Premium SSD v2 disks at any time, permitting workloads to be price environment friendly whereas assembly workload dimension and efficiency necessities.
**With 3 VMs of L16s_v3, you get 11.52 TB of storage allotted by default that’s used to serve the volumes created for PostgreSQL workload. For different VM sizes within the L-Sequence household, the worth per thirty days and allotted storage will range.
For PostgreSQL workloads, the selection between utilizing native NVMe and Premium SSD v2 will depend on balancing efficiency, price, and knowledge sturdiness. Native NVMe through Azure Container Storage presents extraordinarily low latency and excessive throughput, making it appropriate for performance-sensitive PostgreSQL deployments. The prices are increased with native NVMe, and there’s much less flexibility to scale independently of workload traits. Conversely, Premium SSD v2 supplies higher price-performance effectivity and versatile scalability, making it a viable possibility for PostgreSQL situations that require dealing with elevated scale or functions having unpredictable surges in demand or utilization. When it comes to knowledge sturdiness, Premium SSD v2 presents domestically redundancy by default, whereas for native NVMe, it’s endorsed to make use of a replica-based structure managed by CloudNativePG operator and an object storage-based backup method to stop knowledge loss.
Constructed for top availability with CloudNativePG on Azure Kubernetes Service
For groups deploying PostgreSQL in manufacturing, excessive availability and backups are non-negotiable. With the open-source CloudNativePG operator, a extremely accessible PostgreSQL cluster on AKS can simply be deployed with:
- Constructed-in replication and automatic failover.
- Utility constant backup with native integration with Azure Blob Storage.
- Seamless integration with Azure Container Storage.
- Versatile storage choices: select Premium SSD v2 or native NVMe primarily based on workload wants.
Whether or not you’re supporting inside enterprise apps or customer-facing platforms, this offers you peace of thoughts with out the effort of hand-building customized excessive availability logic and separate backup workflows. Get began with deploying extremely accessible PostgreSQL on AKS with CloudNativePG operator utilizing our step-by-step reference information.
Prepared for the longer term
PostgreSQL is only one of many stateful workloads that organizations are actually confidently operating on Azure Kubernetes Service. From databases to message queues, AI inferencing, and enterprise functions, AKS is evolving to fulfill the wants of persistent, data-heavy functions in manufacturing.
Whether or not you’re deploying Redis, MongoDB, Kafka, and even ML-serving pipelines with GPU-backed nodes, AKS supplies the inspiration to handle these workloads with efficiency, consistency, and operational ease, together with clear end-to-end steering.
With improvements like Azure Container Storage for native NVMe and Premium SSD v2 for scalable persistent storage, we’re making it simpler than ever to construct stateful functions which might be: dependable, performant, and value environment friendly for mission essential workloads.
Modernize your knowledge layer on Kubernetes at this time. Whether or not you’re operating PostgreSQL or any stateful tier, Azure delivers the efficiency and manageability to make it occur. Discover confirmed patterns and deployment choices within the AKS Stateful Workloads Overview.
