The partition key is the one partitioning decision you mostly cannot undo. Here is how to choose it, why hash on a skewed column backfires, and how to match the key to your workload.

Two failure modes produce the same "database is locked up" alert in PostgreSQL. Here is how to tell a true lockup from a stale connection, and fix the right one.