Build scalable apps in Azure Cosmos DB for PostgreSQL

Important

Azure Cosmos DB for PostgreSQL is no longer supported for new projects. Don't use this service for new projects. Instead, use one of these two services:

• Use Azure Cosmos DB for NoSQL for a distributed database solution designed for high-scale scenarios with a 99.999% availability service level agreement (SLA), instant autoscale, and automatic failover across multiple regions.

• Use the Elastic Clusters feature of Azure Database For PostgreSQL for sharded PostgreSQL using the open-source Citus extension.

There are three steps involved in building scalable apps with Azure Cosmos DB for PostgreSQL:

1. Classify your application workload. There are use-case where Azure Cosmos DB for PostgreSQL shines: Multitenant SaaS, microservices, real-time operational analytics, and high throughput OLTP. Determine whether your app falls into one of these categories.
2. Based on the workload, use schema-based sharding or identify the optimal shard key for the distributed tables. Classify your tables as reference, distributed, or local.
3. When using row-based sharding, update the database schema and application queries to make them go fast across nodes.

Next steps

Before you start building a new app, you must first review a little more about the architecture of Azure Cosmos DB for PostgreSQL.

Fundamental concepts for scaling >