News for hackers. Stuff that matters.

A comment on Understanding How UUIDs Are Generated. Parent comment

Re:Understanding How UUIDs Are Generated by marcus_holmes on Thursday October 01, 2020 @09:16AM (#24650463)
Well, for some databases, yes, this is "clustering", and there's a command to deal with it ([0] is postgres, which doesn't do this particularly well, other flavours of database have similar commands).

But it's the usual thing with databases: if you're trying to optimise performance by hacking the engine, then your schema probably needs a good hard looking at.

[0] https://www.postgresql.org/docs/current/sql-cluster.html

[ Parent | on HN ]
Re:Understanding How UUIDs Are Generated by lazulicurio on Thursday October 01, 2020 @11:39AM (#24652159)
I don't consider being aware of your data distribution to be "hacking the engine". It's part of a good DBA's job. For any data set of appreciable size you can't treat the data as a black box. Even if you're not clustering the underlying table in postgres the performance of your indices will be heavily affected by data layout.
[ Parent | on HN ]
Re:Understanding How UUIDs Are Generated by marcus_holmes on Friday October 02, 2020 @08:41AM (#24661979)
I agree. Hacking the ID field to include index data so the storage clustering is a bit more performant is not "treating the data as a black box" to my mind.
[ Parent | on HN ]