News for hackers. Stuff that matters.
Re:How to Get the Most Out of Postgres Memory Settings by hot_gril on Wednesday June 12, 2024 @07:52PM (#40664444)
Postgres hash indexes were sorta unusable until a few years ago, and in my experience they weren't any faster back then. Haven't tried again recently, but if I did, I would run benchmarks before trusting it. Also, giving credit where it's due, someone on HN showed me why even this option is less scalable in theory than a btree with semi-ordered keys: https://news.ycombinator.com/item?id=40590760

Still, UUID4 is a good default for publicly visible IDs since anything else leaks info. But there's almost no need to have one as a PK.

There are no comments on this comment yet.