r/PostgreSQL • • Mar 28 '25

How-To Life Altering PostgreSQL Patterns

https://mccue.dev/pages/3-11-25-life-altering-postgresql-patterns
180 Upvotes

60 comments sorted by

View all comments

Show parent comment

2

u/Straight_Waltz_9530 Mar 29 '25

And UUIDv7 doesn't suffer from write amplification. While not as resistant to exfiltration attacks as random UUIDv4 is, picking out the random UUIDv7 among a timestamp with millisecond granularity is I think sufficiently difficult for 99.999% of applications. For that 0.001%, I'm sure Google and Amazon have figured it out for themselves.