partitions are often used to drop old data in constant time. They can also help ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		iTokio on Aug 19, 2024 \| parent \| context \| favorite \| on: Show HN: PgQueuer – Transform PostgreSQL into a Jo... 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.

jashmatthews on Aug 19, 2024 [–]

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

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact