8 ms·
How do you know it would have worked out better with UUIDs? Did you load test it? What's the size of your dataset?
by perfectspiral 2y ago
How do you know it would have worked out better with UUIDs? Did you load test it? What's the size of your dataset?
- bruce511 2y agoWith bigint primary keys the process starts either taking the old site offline, and ends with bringing the new site online. In-between is a non-trivial renumbering step, which takes measurable time that invalidates all existing backups. By contrast uuid based databases do not need this step, and all existing data (some steady distributed, some in backups etc) remain valid.