Azure VM and disk recommendation

Question

I want to have your recommendation for vm and disk on Azure. Here is my requirements. And I want to install postgreSQL 14 on it.

Data location : /pgdbfiles => 1 Tb

Internal memory : => 32 Gb

Number vcpu’s : => 16

Filesystem for log shipping wal files => 100 Gb

OS => Red Hat Enterprise Linux release 8.5

Doc: https://learn.microsoft.com/en-us/azure/virtual-machines/sizes — CSharpRocks, Dec 02 '22 at 10:51
Impossible to answer because we have no idea what the load will be, data model, query efficiency, etc — Frank Heikens, Dec 02 '22 at 17:50

score 0 · Accepted Answer · answered Dec 02 '22 at 13:02

0

The size of the VM recommended for your requirement is F16s_v2

Data location disk: a Premium SSD LRS of 1024 GiB is recommended, but it will depend on how high the IOPS for the database is.

Filesystem for log shipping wal files: This could be an Standard HDD of 128 GiB, again it will depend on the IOPS for that disk.

You can use Red Hat Enterprise Linux 8.5 (LVM) - Gen 2 as OS image for the OS.

hope this helps!

answered Dec 02 '22 at 13:02

SoySolisCarlos

thank you very much for your prompt response. I have one more question about Red Hat Enterprise Linux. Do we need to pay extra cost for the licence or it is included in the azure subscription? – bizimunda Dec 02 '22 at 13:10
1

Quoting MS: "Red Hat Enterprise Linux (RHEL) images are available in Azure via a pay-as-you-go or bring-your-own-subscription (BYOS) (Red Hat Gold Image) model. " – user_0 Dec 02 '22 at 15:46

1 Answers1