Edit

Share via

Compute options in Azure Database for PostgreSQL - Flexible Server

  • Article

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.

Related content