top | item 40011262

(no title)

perfectspiral | 1 year 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?

discuss

order

bruce511|1 year ago

With 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.