About the Workload type option of PostgreSQL Flexible server

Question

I use Azure Database for PostgreSQL to build a DB environment. I would like to ask the following questions regarding the Workload type selection items. When selecting Production (Large-size), there was a description of availability, but when selecting Production (Small / Medium-size), there was no description of availability. In fact, both have availability options, but why isn't availability mentioned in the Production (Small / Medium-size) description?

What is the specific difference between Production (Large-size) and Production (Small / Medium-size)?

I am looking forward to your answer. thank you.

Answer 1

Production (Large-size)

• It is suitable for production, pre-production or testing large databases with high concurrency and availability requirements?.
• It is a little expensive because it provides server with high configuration eg. 2 vCores, 16 GiB RAM, 512 GiB storage It is default server.
• It has target workloads that require in-memory performance for faster transaction processing. Examples include servers for processing real-time data and high-performance transactional or analytical apps.
• It has Memory Optimized pricing tier by default.

Production (Small / Medium-size)

• It is suitable for production, pre-production or testing of small to medium size databases with low-medium concurrency requirements?.

• It is cheaper than Production (Large-size) because it provides server with lower configuration eg. 2 vCores, 8 GiB RAM, 128 GiB storage It is default server.

• It has target 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.

• It has General Purpose pricing tier by default.