Re: alter table is taking a long time

2009/11/7 stanciutheone@gmail.com <stanciutheone@gmail.com>:
> There is no one that can tell me what i can do here, or they will do
> here
>
> I'm thinking to restart postgrsql but what will happen with my table
> that i'm just altering just a filter
>
>
> On Nov 7, 2:38 am, "stanciuthe...@gmail.com" <stanciuthe...@gmail.com>
> wrote:
>> 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
>
>
Does the column you're altering have a check constraint, primary key
(possibly with cascade on it) or an index on it?  And what is the
structure of the inheritance?  For example, do you have a
straightforward 1 parent, many children tree?

Thom