alter table is taking a long time - Mailing list pgsql-general

From stanciutheone@gmail.com
Subject alter table is taking a long time
Date
Msg-id e2834399-236b-4032-be6b-73688bd04a0a@v30g2000yqm.googlegroups.com
Whole thread Raw
List 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

pgsql-general by date:

Previous
From: "stanciutheone@gmail.com"
Date:
Subject: Re: alter table is taking a long time
Next
From: Thom Brown
Date:
Subject: Re: alter table is taking a long time