How should database partitioning be applied in a production system?

Select keys from access patterns, plan redistribution, understand cross-partition queries, and monitor skew. The implementation should be justified by measurable requirements, kept as simple as the problem allows, and validated with realistic tests, telemetry, failure handling, and documented tradeoffs.