3 ms·
Quick question. So you’re saying use bigserial for PK (instead of uuid) and have another column where I set a uuid in case of application level identifier. But
by moomoo11 2y ago
Quick question. So you’re saying use bigserial for PK (instead of uuid) and have another column where I set a uuid in case of application level identifier.
But wouldn’t that require a index on it if it’s going to be an identifier that’s used to query?
- VWWHFSfQ 2y agoYes but you only have a single index containing the UUIDs instead of duplicated everywhere that is using it as a foreign key relation. Those indexes quickly become explosive in relations like e.g. m2m tables.
- deleted 2y ago[deleted]