adding a column takes FOREVER!

From: Eric Smith <eric_h_smith(at)mac(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: adding a column takes FOREVER!
Date: 2011-10-21 22:45:02
Message-ID: 25C3A970-3FD6-401D-A879-3D310066DCA0@mac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

All,

I'm adding a column in postgres 8.3 with the syntax: alter table images add column "saveState" varchar(1) default '0'; It takes a good solid 20 minutes to add this column to a table with ~ 14,000 entries. Why so long? Is there a way to speed that up? The table has ~ 50 columns.

Thanks,
Eric

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-10-21 23:45:11 Re: postgres/postgis eats memory
Previous Message miesi 2011-10-21 20:48:17 Anyone using the solaris 11 precompiled binaries on opensolaris snv_134