Database Case Studies

Specific databases taken apart: how they store and replicate data, and the tricks that make them fast.

• Database optimization tricks in Postgres — a running collection of Postgres tricks, one section per trick.
• Locking and isolation levels in Postgres — isolation levels, row locks, and not selling seat 42 twice.
• Primer on MongoDB — from the document model and queries to sharding, chunk rebalancing and the storage engine.