On 2021-09-29 11:42:42 +0200, Tobias Meyer wrote: > Possible drawbacks: > > * The ids will grow faster, and they will be large even on small > tables. It may be a bit irritating if you have a table with just 5 > rows and the ids are 5, 6, 7, 12654, 345953. [...] > > * you will have to pay attention to rollover/overflow situations more > quickly.
I'd subsume this under "ids will grow faster".
But I would actually see that as an advantage:
* All your ids have the same type, so either 32 bit is enough for
everything or you use 64 bit (do the latter if in doubt).
* You only have to monitor a single sequence to see if you are close to
an overflow, not dozens of them.
* You will probably be more aware that this might be a problem.
hp
--
_ | Peter J. Holzer | Story must make more sense than reality.
|_|_) | |
| | | h...@hjp.at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
signature.asc
Description: PGP signature
