Add Range Partitioning to a Large Table
Vertical vs horizontal vs sharding, range/hash/list strategies, Postgres declarative partitioning + pg_partman, drop-old-partitions instead of DELETE, Cosmos hierarchical partition keys, verifying pruning with EXPLAIN.
Build: Add Range Partitioning to a Large Table
A guided implementation with code you can run and adapt for production.
Reading Partitioning is free. Pro unlocks the other four modes on all Databases topics, so you can go from understanding it to building it.
- SeeThe architecture as diagrams, so you can hold the whole system in your head.
- AnimateStep through the flow one stage at a time and watch the data move.
- TestScenario questions with explanations that show exactly where your model of it breaks.
- BuildA guided implementation with code you can run and adapt for production.
Continue reading
All Databases articles →Vector Database Selection for Production RAG
Cosmos DB, AI Search, Qdrant, Pinecone — benchmarks, cost, and operational complexity for production vector search.
Normalization: 1NF to 3NF, Denormalize Reads, Snapshot Truths
1NF/2NF/3NF/BCNF in plain English, when to denormalize via materialized views or CQRS read models, snapshots vs duplication, REFRESH MATERIALIZED VIEW CONCURRENTLY, propagating changes via CDC.
Schema Design: Keys, Relationships, Tenancy, and Audit
Surrogate (UUIDv7/bigint) vs natural keys, foreign keys + CHECK constraints, audit columns + history triggers, soft delete with partial indexes, multi-tenancy patterns + Postgres RLS, junction tables for N:N.
Discussion
Sign in to share your feedback and join the discussion.