[dholowiski]

While I don't disagree with the coolness of uuid, how exactly do you 'run out of integers' ?

[dmm]

Here's a good example:

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]

Same thing happened to Twitter: http://techcrunch.com/2009/06/12/all-hell-may-break-loose-on...

[olefoo]

It'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....

Fortunately the PostgreSQL has autovacuum so you probably don't need to worry about this.

[jeltz]

Yeah, running out of a bigint in PostgreSQL would be hard since they are 63 bits + sign.