What is database partitioning?

Partitioning divides a large logical dataset into smaller portions according to a partitioning rule. Depending on the database technology, partitions may remain within one database system or be distributed across different nodes.

Partitioning can improve manageability and some query patterns, but the partition key must match access patterns. Poor partitioning can create hot partitions or expensive cross-partition operations.