[perfectspiral]

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]

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.