Comment on Twitter's UID associated to each tweet will very soon exceed 2,147,483,647parentComments−fleaflicker17yThat command will take several hours to complete and write lock the table.−Andys17yUnless you use PostgreSQL.But then you would have had 64 bit ID by default anyway.−jsonscripter17yWhy can't you just redirect the writes to a new temporary table and join the original and temporary on reads? (I'm not a database admin)−karanbhangui17yI'm actually interested in this answer as well. I know of a company using a proprietary db and now that their growth has literally exploded, they're stuck with it.−jsonscripter17yI wonder what literally exploding growth looks like...−blhack17yhttp://dhawhee.blogs.com/d_hawhee/files/109_fake_tits_real_b...−TweedHeads17yNothing the fail whale can't fix ;-)
Comments
That command will take several hours to complete and write lock the table.
Unless you use PostgreSQL.
But then you would have had 64 bit ID by default anyway.
Why can't you just redirect the writes to a new temporary table and join the original and temporary on reads? (I'm not a database admin)
I'm actually interested in this answer as well. I know of a company using a proprietary db and now that their growth has literally exploded, they're stuck with it.
I wonder what literally exploding growth looks like...
http://dhawhee.blogs.com/d_hawhee/files/109_fake_tits_real_b...
Nothing the fail whale can't fix ;-)