Postgres Pro
Downloads
Home   >   mailing lists

Re: alter table on a large db - Mailing list pgsql-sql

From Jasen Betts
Subject Re: alter table on a large db
Date
Msg-id gqa8c8$kv1$2@reversiblemaps.ath.cx
Whole thread Raw
In response to alter table on a large db  (Zdravko Balorda <zdravko.balorda@siix.com>)
List pgsql-sql
Tree view 
On 2009-03-19, Zdravko Balorda <zdravko.balorda@siix.com> wrote:
>
> Hi,
>
> I need to make some ALTER TABLEs. It takes about 30min to copy
> this quite large databse, bat several ours to run a bunch of ALTER
> TABLE statements.

which do you prefer 30 minutes down-time to reload the database or a
few hours wait to update it live.

> Is there any way to make it faster? I wonder what could possibly alter 
> table be doing all this time.

drop and reload the table?

pgsql-sql by date:

Previous
From: Zdravko Balorda
Date:
Subject: Alter Table/Indexing
Next
From: Jasen Betts
Date:
Subject: Re: cast bool/int