Internal engineering guide covering Postgres production operations from schema design and indexing through advanced topics like partitioning and FOR UPDATE SKIP LOCKED.

Addresses query planner behavior, bulk writes, autovacuum tuning, and migration strategies. Assumes basic SQL knowledge and notes that many scaling optimizations require writing raw SQL rather than relying on ORM abstractions.