Hacker News new | ask | show | jobs
by iTokio 662 days 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.

1 comments

Yeah the ULID/UUIDs which can be be partitioned by time in this way are AWESOME for these use cases.