I only use uuid as PK in Postgres. So many benefits, it is easy to migrate data between environments, client can generate its own ids etc. I don’t know about p

I only use uuid as PK in Postgres. So many benefits, it is easy to migrate data between environments, client can generate its own ids etc. I don’t know about performance but I think in most cases that is not a big concern anyway.