Build scalable apps
APPLIES TO: PostgreSQL
There are three steps involved in building scalable apps with Azure Cosmos DB for PostgreSQL:
- Classify your application workload. There are use-case where Azure Cosmos DB for PostgreSQL shines: multi-tenant SaaS, real-time operational analytics, and high throughput OLTP. Determine whether your app falls into one of these categories.
- Based on the workload, identify the optimal shard key for the distributed tables. Classify your tables as reference, distributed, or local.
- Update the database schema and application queries to make them go fast across nodes.
Before you start building a new app, you must first review a little more about the architecture of Azure Cosmos DB for PostgreSQL.