4 ms·
ALTER SEQUENCE users_id_seq RESTART WITH 54321; "Wow, this service is probably mature, well-tested and reliable!"
by petepete 7y ago
ALTER SEQUENCE users_id_seq RESTART WITH 54321;
"Wow, this service is probably mature, well-tested and reliable!"
- zepolen 7y agoAmateur - you have to do over 1 million or you're not web scale.
- lifthrasiir 7y agoNote that there is a legitimate reason to set the initial sequence in this way: oftentimes the system works fine with 31/32-bit numbers but not with larger ones. Starting with the large sequence number (we have frequently used 10 billion) proactively eliminates this problem.
- koolba 7y agoAnd then come back a week later to see that 500001 => 500004...
- TeMPOraL 7y agoThe number of users who notice the user ID is a small fraction of your total users. The number of users who would notice the ID didn't grow much over the week is a small fraction of that fraction.
- zAy0LfpBZLC8mAC 7y agoNamely, cour competition that tries to figure out what to do about you or whether to even care, yes.
- dexterdog 7y agoExactly. I have done this in research on competition many times.