Speeding up schema changes

From: "Stefan Arentz" <stefan(dot)arentz(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Speeding up schema changes
Date: 2007-09-03 11:22:15
Message-ID: adf34c300709030422p7a5bf9ban915c01547c3cb008@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Is there a way to speed up simple schema changes like ...

ALTER TABLE foo ADD COLUMN bar CHAR(64);

... where foo already contains millions of records?

On a live database changes like this can take hours. Even when the
database is idle.

Is there a better way to do this?

S.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Gregory Stark 2007-09-03 12:26:29 Re: Speeding up schema changes
Previous Message Rodrigo De León 2007-09-02 21:20:51 Re: PK & FK & Index Questio