Skip site navigation (1) Skip section navigation (2)

the grass on the other side of the hill

From: Vassilis Papadimos <vpapad(at)cs(dot)pdx(dot)edu>
To: pdxpug(at)postgresql(dot)org
Subject: the grass on the other side of the hill
Date: 2006-11-09 18:01:17
Message-ID: 45536CED.3090103@cs.pdx.edu (view raw or flat)
Thread:
Lists: pdxpug
 From http://slashdot.org/article.pl?sid=06/11/09/1534204

"Last night we crossed over 16,777,216 comments in the database. The 
wise amongst you might note that this number is 2^24, or in MySQLese an 
unsigned mediumint. Unfortunately, like 5 years ago we changed our 
primary keys in the comment table to unsigned int (32 bits, or 4.1 
billion) but neglected to change the index that handles parents. We're 
awesome! Fixing is a simple ALTER TABLE statement... but on a table that 
is 16 million rows long, our system will take 3+ hours to do it, during 
which time there can be no posting. So today, we're disabling threading 
and will enable it again later tonight. Sorry for the inconvenience. We 
shall flog ourselves appropriately."

Hilarious!

Vassilis.

Responses

pdxpug by date

Next:From: Selena DeckelmannDate: 2006-11-09 18:46:23
Subject: Re: the grass on the other side of the hill
Previous:From: Rich ShepardDate: 2006-10-31 03:49:10
Subject: Re: Pricing Database Project

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group