3 ms·
While I don't disagree with the coolness of uuid, how exactly do you 'run out of integers' ?
by dholowiski 12y ago
While I don't disagree with the coolness of uuid, how exactly do you 'run out of integers' ?
- dmm 12y agoHere's a good example: http://slashdot.org/story/06/11/09/1534204/slashdot-posting-bug-infuriates-haggard-admins http://slashdot.org/story/06/11/09/1534204/slashdot-posting-... Slashdot got over 16,777,216 comments overflowing a MySQL mediumint they were using for an index.
- daigoba66 12y agoSame thing happened to Twitter: http://techcrunch.com/2009/06/12/all-hell-may-break-loose-on-twitter-in-2-hours/ http://techcrunch.com/2009/06/12/all-hell-may-break-loose-on...
- jeltz 12y agoYeah, running out of a bigint in PostgreSQL would be hard since they are 63 bits + sign.
- olefoo 12y agoIt's called transaction id wraparound, and you don't want to allow it to happen. http://www.postgresql.org/docs/9.3/static/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND http://www.postgresql.org/docs/9.3/static/routine-vacuuming.... Fortunately the PostgreSQL has autovacuum so you probably don't need to worry about this.