News for hackers. Stuff that matters.
Re:UUID, serial or identity columns for PostgreSQL auto-gene... by fatsdomino001 on Monday May 31, 2021 @05:20PM (#27348117)
I was debating between using ULID vs just using the same sequential bigint sharding strategy that Instagram uses[1][2].

I ended up deciding to use sharded bigints because it enables better indexing, even though there are drawbacks when first writing the instances; The benefit of faster search was more important for me.

[1]: https://instagram-engineering.com/sharding-ids-at-instagram-...

[2]: http://www.livinginthepast.org/2016/02/24/sharding-into-bigi...

There are no comments on this comment yet.