System Design Aug 4, 2026 10 min read
Table Partitioning and Partition Pruning Explained
Learn PostgreSQL table partitioning, partition keys, pruning, lifecycle maintenance, indexes, constraints, prepared queries, and production validation.
Tag
Scalability
6 articles with this tag. Follow these related notes when you want a narrower study path.
System Design Aug 2, 2026 10 min read
Bulkhead Pattern and Resource Isolation Explained
Contain backend failures by isolating concurrency, threads, connection pools, and queues across priorities, tenants, operations, and dependencies.
System Design Aug 2, 2026 10 min read
Load Shedding and Adaptive Concurrency Limits Explained
Protect backend latency and useful throughput with explicit admission, deliberate load shedding, and evidence-tuned concurrency limits.
System Design Jul 25, 2026 9 min read
Database Read Replicas Explained
Learn how database read replicas work, where replica lag breaks correctness, and how to route reads safely in Spring and Node.js services.
System Design Jun 29, 2026 6 min read
Database Sharding Explained
Learn what database sharding is, when backend systems need it, how shard keys work, and what tradeoffs sharding creates.
System Design Jun 29, 2026 5 min read
Load Balancing Explained
Learn how load balancing distributes traffic across backend servers, including algorithms, health checks, sticky sessions, and tradeoffs.