[ADMIN] Altering a column (increasing size) in Postgres takes long time

We have a huge table with hundred million records. We need to increase the size of an existing column with varchar type, and it has been running for more than 12 hours. We're using: ALTER TABLE Property ALTER COLUMN "situs-number" TYPE varchar(30); The index on that column has been dropped

Re: [ADMIN] Altering a column (increasing size) in Postgres takes long time

On Thu, Feb 25, 2010 at 6:04 PM, Tomeh, Husam wrote: > We have a huge table with hundred million records. We need to increase the > size of an existing column with varchar type, and it has been running for > more than 12 hours. > > > > We’re using: ALTER TABLE Property ALTER COLUMN "situs-number"