Partition Pruning in Action
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.
Animate: Partition Pruning in Action
Step through the flow one stage at a time and watch the data move.
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.