Range
Partition by date range. Time-series primary use. Old partitions detached + dropped for retention.
Advertisement
List
Partition by discrete values. E.g., per country. Query with WHERE country = ? hits only relevant.
Advertisement
Hash
Partition by hash. Balanced load. Loses range scan benefit within partition.