Re: alter table on a large db

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: alter table on a large db
Date: 2009-03-24 09:15:52
Message-ID: gqa8c8$kv1$2@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 2009-03-19, Zdravko Balorda <zdravko(dot)balorda(at)siix(dot)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?

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jasen Betts 2009-03-24 09:28:58 Re: cast bool/int
Previous Message Zdravko Balorda 2009-03-24 08:55:06 Alter Table/Indexing