From: | Thom Brown <thombrown(at)gmail(dot)com> |
---|---|
To: | "stanciutheone(at)gmail(dot)com" <stanciutheone(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: alter table is taking a long time |
Date: | 2009-11-07 06:29:13 |
Message-ID: | bddc86150911062229k462ecc5bq3cbb9982ae6a1446@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2009/11/7 stanciutheone(at)gmail(dot)com <stanciutheone(at)gmail(dot)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(dot)(dot)(dot)(at)gmail(dot)com" <stanciuthe(dot)(dot)(dot)(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Harris | 2009-11-07 06:41:07 | Re: alter table is taking a long time |
Previous Message | stanciutheone@gmail.com | 2009-11-07 05:55:29 | Re: alter table is taking a long time |