Compute options in Azure Database for PostgreSQL - Flexible Server
APPLIES TO: Azure Database for PostgreSQL - Flexible Server
You can create an Azure Database for PostgreSQL flexible server instance in one of three pricing tiers: Burstable, General Purpose, and Memory Optimized. The pricing tier is calculated based on the compute, memory, and storage you provision. A server can have one or many databases.
Resource/Tier | Burstable | General Purpose | Memory Optimized |
---|---|---|---|
VM-series | B-series | Ddsv5-series, Dadsv5-series, Ddsv4-series, Dsv3-series |
Edsv5-series, Eadsv5-series, Edsv4-series, Esv3-series |
vCores | 1, 2, 4, 8, 12, 16, 20 | 2, 4, 8, 16, 32, 48, 64, 96 | 2, 4, 8, 16, 20 (v4/v5), 32, 48, 64, 96 |
Memory per vCore | Variable | 4 GiB | 6.75 GiB to 8 GiB |
Storage size | 32 GiB to 64 TiB | 32 GiB to 64 TiB | 32 GiB to 64 TiB |
Automated Database backup retention period | 7 to 35 days | 7 to 35 days | 7 to 35 days |
Long term Database backup retention period | up to 10 years | up to 10 years | up to 10 years |
To choose a pricing tier, use the following table as a starting point:
Pricing tier | Target workloads |
---|---|
Burstable | Workloads that don't need the full CPU continuously. |
General Purpose | Most business workloads that require balanced compute and memory with scalable I/O throughput. Examples include servers for hosting web and mobile apps and other enterprise applications. |
Memory Optimized | High-performance database workloads that require in-memory performance for faster transaction processing and higher concurrency. Examples include servers for processing real-time data and high-performance transactional or analytical apps. |
After you create a server for the compute tier, you can change the number of vCores (up or down) and the storage size (up) in seconds. You also can independently adjust the backup retention period up or down. For more information, see the Scaling resources in Azure Database for PostgreSQL flexible server page.
Compute tiers, vCores, and server types
You can select compute resources based on the tier, vCores, and memory size. vCores represent the logical CPU of the underlying hardware.
The detailed specifications of the available server types are as follows:
SKU name | vCores | Memory size | Maximum supported IOPS | Maximum supported I/O bandwidth |
---|---|---|---|---|
Burstable | ||||
B1ms | 1 | 2 GiB | 640 | 10 MiB/sec |
B2s | 2 | 4 GiB | 1,280 | 15 MiB/sec |
B2ms | 2 | 8 GiB | 1,920 | 22.5 MiB/sec |
B4ms | 4 | 16 GiB | 2,880 | 35 MiB/sec |
B8ms | 8 | 32 GiB | 4,320 | 50 MiB/sec |
B12ms | 12 | 48 GiB | 4,320 | 50 MiB/sec |
B16ms | 16 | 64 GiB | 4,320 | 50 MiB/sec |
B20ms | 20 | 80 GiB | 4,320 | 50 MiB/sec |
General Purpose | ||||
D2s_v3 / D2ds_v4 | 2 | 8 GiB | 3,200 | 48 MiB/sec |
D2ds_v5 / D2ads_v5 | 2 | 8 GiB | 3,750 | 85 MiB/sec |
D4s_v3 / D4ds_v4 | 4 | 16 GiB | 6,400 | 96 MiB/sec |
D4ds_v5 / D4ads_v5 | 4 | 16 GiB | 6,400 | 145 MiB/sec |
D8s_v3 / D8ds_v4 | 8 | 32 GiB | 12,800 | 192 MiB/sec |
D8ds_v5 / D8ads_v5 | 8 | 32 GiB | 12,800 | 290 MiB/sec |
D16s_v3 / D16ds_v4 | 16 | 64 GiB | 25,600 | 384 MiB/sec |
D16ds_v5 / D16ds_v5 | 16 | 64 GiB | 25,600 | 600 MiB/sec |
D32s_v3 / D32ds_v4 | 32 | 128 GiB | 51,200 | 768 MiB/sec |
D32ds_v5 / D32ads_v5 | 32 | 128 GiB | 51,200 | 865 MiB/sec |
D48s_v3 / D48ds_v4 | 48 | 192 GiB | 76,800 | 1152 MiB/sec |
D48ds_v5 / D48ads_v5 | 48 | 192 GiB | 76,800 | 1200 MiB/sec |
D64s_v3 / D64ds_v4 / D64ds_v5/ D64ads_v5 | 64 | 256 GiB | 80,000 | 1200 MiB/sec |
D96ds_v5 / D96ads_v5 | 96 | 384 GiB | 80,000 | 1200 MiB/sec |
Memory Optimized | ||||
E2s_v3 / E2ds_v4 | 2 | 16 GiB | 3,200 | 48 MiB/sec |
E2ds_v5 / E2ads_v5 | 2 | 16 GiB | 3,200 | 85 MiB/sec |
E4s_v3 / E4ds_v4 | 4 | 32 GiB | 6,400 | 96 MiB/sec |
E4ds_v5 / E4ads_v5 | 4 | 32 GiB | 6,400 | 145 MiB/sec |
E8s_v3 / E8ds_v4 | 8 | 64 GiB | 12,800 | 192 MiB/sec |
E8ds_v5 / E8ads_v5 | 8 | 64 GiB | 12,800 | 290 MiB/sec |
E16s_v3 / E16ds_v4 | 16 | 128 GiB | 25,600 | 384 MiB/sec |
E16ds_v5 / E16ds_v5 | 16 | 128 GiB | 25,600 | 600 MiB/sec |
E20ds_v4 | 20 | 160 GiB | 32,000 | 480 MiB/sec |
E20ds_v5 / E20ads_v5 | 20 | 160 GiB | 32,000 | 750 MiB/sec |
E32s_v3 / E32ds_v4 | 32 | 256 GiB | 51,200 | 768 MiB/sec |
E32ds_v5 / D32ads_v5 | 32 | 256 GiB | 51,200 | 865 MiB/sec |
E48s_v3 / E48ds_v4 / E48ds_v5 / E48ads_v5 | 48 | 384 GiB | 76,800 | 1152 MiB/sec |
E48ds_v5 / E48ads_v5 | 48 | 384 GiB | 76,800 | 1200 MiB/sec |
E64s_v3 / E64ds_v4 | 64 | 432 GiB | 80,000 | 1200 MiB/sec |
E64ds_v5 / E64ads_v4 | 64 | 512 GiB | 80,000 | 1200 MiB/sec |
E96ds_v5 /E96ads_v5 | 96 | 672 GiB | 80,000 | 1200 MiB/sec |
Important
Minimum and maximum IOPS are also determined by the storage tier so please choose a storage tier and instance type that can scale as per your workload requirements.
Price
For the most up-to-date pricing information, see the Azure Database for PostgreSQL flexible server pricing page. The Azure portal shows the monthly cost on the Pricing tier tab, based on the options that you select.
If you don't have an Azure subscription, you can use the Azure pricing calculator to get an estimated price. On the Azure pricing calculator website, select Add items, expand the Databases category, and then select Azure Database for PostgreSQL to customize the options.