Partition, partition key

Also written: partitioning, partitions, partition key, PARTITION BY RANGE, list partitioning, hash partitioning

Partitioning splits one big table into smaller tables (partitions) that Postgres treats as one. The partition key is the column that decides where a row goes. Range, list and hash are the ways to split.