adding a column takes FOREVER! - Mailing list pgsql-general

From Eric Smith
Subject adding a column takes FOREVER!
Date
Msg-id 25C3A970-3FD6-401D-A879-3D310066DCA0@mac.com
Whole thread Raw
Responses Re: adding a column takes FOREVER!  (Craig Ringer <ringerc@ringerc.id.au>)
Re: adding a column takes FOREVER!  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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
speedthat up?  The table has ~ 50 columns. 

Thanks,
Eric


pgsql-general by date:

Previous
From: Ronan Dunklau
Date:
Subject: Re: Postgresql - FDW, ForeignScanState and subqueries
Next
From: Craig Ringer
Date:
Subject: Re: postgres/postgis eats memory