Craig digs into multitenancy applications, sharding, and the Citus extension. He gives several approaches to the data design so that you're ready to scale if and when that time comes.

CrunchyData's platform is a central hub for PostgreSQL professionals and database administrators, offering insights into PostgreSQL deployment, administration, and optimization. Through articles, tutorials, and case studies, CrunchyData offers insights into PostgreSQL features, replication strategies, and high availability architectures. Readers can learn about database performance tuning, backup and recovery procedures, and security best practices to ensure the reliability and security of their PostgreSQL deployments.

Crunchy Data

Learn about different design patterns for multi-tenant database design in Postgres, including using separate databases per customer, schemas, and tenant discriminators. Discover how Citus can help with scaling and managing multi-tenant databases.

Designing Your Postgres Database for Multi-tenancy

Three approaches to multi-tenant database design