This is where the v7 argument becomes concrete. Databases can store both UUID v4 and UUID v7. The difference is how inserts behave over time. A random UUID v4 primary key pushes writes across the index range. A time-ordered UUID v7 tends to push new rows closer to the latest part of the index. That usually improves locality.
Better locality can mean fewer page splits, less churn in B-tree structures, and more predictable cache behavior. The exact effect depends on the engine, schema, and workload, but the direction is easy to understand. Ordered values are generally easier on indexes than random values.
For PostgreSQL and MySQL-backed Go applications, this matters most on large, hot tables. The difference may be negligible on a low-volume table with a few thousand rows. It becomes much more visible when the same table sees sustained writes, multiple secondary indexes, and frequent lookups.
There is also a second-order benefit: if your primary key is less chaotic, secondary structures that include that key often behave more predictably too. The main takeaway is not that UUID v7 is magically free. The takeaway is that UUID v7 reduces one of the biggest database costs associated with UUID v4.
If you still want UUID v4 for external APIs, there is also a hybrid option. Some Go systems use an internal ordered key for database efficiency and a UUID for public references. That pattern is sometimes the best compromise when storage and external contracts have different needs.