alter table is taking a long time

From: "stanciutheone(at)gmail(dot)com" <stanciutheone(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: alter table is taking a long time
Date: 2009-11-07 00:38:49
Message-ID: e2834399-236b-4032-be6b-73688bd04a0a@v30g2000yqm.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi
i have main table where and that table i have inherited 64 times, but
today i needed some extra space to a column so i have run an alter
table to one of my columns

the query is running for over 4 hours and i don't have a clue when it
will stop, the storage of this 64 table has around 30 and milions of
records,

Any advices on what i should need to do next,

Regards

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua Berry 2009-11-07 05:02:20 Re: Absolute value of intervals
Previous Message Paul Ramsey 2009-11-06 21:29:27 Re: How do I include PostGIS geofunctions to a new database after I have already installed PostGIS.