I can buy some of those arguments for databases where your indexes are so huge that making them 4x the size would make things a lot more expensive. But outside

I can buy some of those arguments for databases where your indexes are so huge that making them 4x the size would make things a lot more expensive. But outside of that I think you would be hard pressed to find a real world difference. One nice thing about using random IDs is that in a multi master setup you are significantly less likely to run into issues with two nodes generating the same ID for two different rows. Yeah you can set up different offsets and increments but that’s fragile. Also, under what circumstances would you want to change the values of your primary keys?