Multi-tenant architecture patterns (schema-per-tenant, row-level security)
Query optimization and indexing strategies
JSONB for flexible schemas
Full-text search (pg_trgm, tsvector)
Replication and high availability
Connection pooling (PgBouncer)
Migration strategies and zero-downtime deployments
Monitoring and performance tuning