Umair Shahid: Choosing the Right PostgreSQL Partition Key

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.