Re: Upgrade questions

On 2012-03-12, Carson Gross <carsongross(at)gmail(dot)com> wrote:

> We've got a postgres database with *a lot* of data in one table. On the
> order of 100 million rows at this point. Postgres is, of course, handling
> it with aplomb.

> ALTER TABLE my_table ALTER COLUMN id TYPE bigint;

> However, given the size of this table, I have no idea how long something
> like this might take. In general I've had a tough time getting feedback
> from postgres on the progress of a query, how long something might take,
> etc.

I would estimate minutes to hours,

it also depends how many foreign keys must be re-checked.

> So my question is: is there a way to understand roughly how long something
> like this might take? Our DB is out on crappy Amazon ec2 instances, so we
> don't exactly have screamers set up. Any tools I can use?

use the cloud. set up a clone and do some testing,

--
⚂⚃ 100% natural