Re: Upgrade questions - Mailing list pgsql-general

From Jasen Betts
Subject Re: Upgrade questions
Date
Msg-id jkm7ia$d9n$1@reversiblemaps.ath.cx
Whole thread Raw
In response to Upgrade questions  (Carson Gross <carsongross@gmail.com>)
List pgsql-general
On 2012-03-12, Carson Gross <carsongross@gmail.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

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Table growing faster than autovacuum can vacuum
Next
From: hamann.w@t-online.de
Date:
Subject: can these queries be combined into one?