Comment by iTokio
2 years ago
partitions are often used to drop old data in constant time.
They can also help to mitigate io issues if you use your insertion timestamp as the partition key and include it in your main queries.
2 years ago
partitions are often used to drop old data in constant time.
They can also help to mitigate io issues if you use your insertion timestamp as the partition key and include it in your main queries.
Yeah the ULID/UUIDs which can be be partitioned by time in this way are AWESOME for these use cases.