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

From Scott Marlowe
Subject Re: alter table on a large db
Date
Msg-id dcc563d10903190417g3189d87fj8e7023ee1adbcbae@mail.gmail.com
Whole thread Raw
In response to alter table on a large db  (Zdravko Balorda <zdravko.balorda@siix.com>)
List pgsql-sql
On Thu, Mar 19, 2009 at 1:57 AM, 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.
> Is there any way to make it faster? I wonder what could possibly alter table
> be doing all this time.

Which alter table statements are you running in particular?  Most
alter table stuff runs pretty quickly, like adding a column and such.
Just wondering.


pgsql-sql by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: alter table on a large db
Next
From: Emi Lu
Date:
Subject: Re: alter column from varchar(32) to varchar(255) without view re-creation