When picking a primary key for a table, you might pick a UUID, serial, or identity column. Laurenz Albe says you should default to using a bigint sequence, and explains…

When you need to change a table, and we’re talking big changes like changing a column type, adding a constraint, or creating an index, you have to be careful if…