News for hackers. Stuff that matters.

A comment on Exploring PostgreSQL 18's new UUIDv7 support. Parent comment

Re:Exploring PostgreSQL 18's new UUIDv7 support by da_chicken on Saturday October 18, 2025 @09:09AM (#45627051)
Are there really any performances benefits of UUIDv7 over UUIDv4 that should ever come up in the context of an HR system? Just how many job applicants are you tracking?

I don't understand why you considered UUIDv7 in the first place.

[ Parent | on HN ]
Re:Exploring PostgreSQL 18's new UUIDv7 support by MikeNotThePope on Saturday October 18, 2025 @01:16PM (#45628864)
You can sort records by ID, retrieve the last N records by ID, etc. It's just easier than using a timestamp.
[ Parent | on HN ]
Re:Exploring PostgreSQL 18's new UUIDv7 support by Incipient on Sunday October 19, 2025 @09:33AM (#45634020)
The guaranteed lack of collision is a big one. I pretty much always add an updated column, and sqlalchemy essentially gives you both for free.
[ Parent | on HN ]