Hi @Jie Shen , welcome to Microsoft Q&A forum.
The workload type option indirectly specifies the default SKU for configuring the PostgreSQL Server as mentioned below:
- **Production (Small / Medium-size)**: This is equivalent of selecting a 'General Purpose, D2ds_v4, 2 vCores, 8 GiB RAM, 128 GiB storage'.
- **Production (Large-size)**: This is equivalent of selecting a 'Memory Optimized, E2ds_v4, 2 vCores, 16 GiB RAM, 512 GiB storage'
- Development: This is equivalent of selecting a 'Burstable, B1ms, 1 vCores, 2 GiB RAM, 32 GiB storage'.
Now these are all default values of server and SKU when we choose respective workload type. We can still go ahead and change these values.
As an example, if I select '***Production (Small / Medium-size)***', by default high availability option will not be selected and we need to explicitly choose it as mentioned in below screenshot. But for '***Production (Large-size)***' high availability is already selected.
For 'Development' as it defaults to 'Burstable (1-2 vCores)' SKU, there is no option of high availability available. So if we want high availability we need to change the SKU to 'General Purpose'.
So precisely, difference between these workloads is the suitable default SKU selection between Burstable, General Purpose and Memory Optimized and these SKU can still be changed for any of these workload types explicitely.
Please let us know if this helps or else we can discuss further on the same.
If answer is helpful please click on as it could help other members of the Microsoft Q&A community who have similar questions and are looking for solutions. Thank you for helping to improve Microsoft Q&A!