Benefits of using auto incrementing primary keys?
Is there any benefit of using auto incrementing columns as primary keys in postgres when I have another column that is unique and can be used as a primary key?
5 Replies
storage + speed to compare
The problem with using a UUID primary key in MySQL — PlanetScale
Understand the different versions of UUIDs and why using them as a primary key in MySQL can hurt database performance.
So, an auto incrementing primary key uses less space and is hence faster to query?
without going too deep into db archtecture
yeah
Hm, makes sense.