Re: 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: Re: alter table is taking a long time
Date: 2009-11-07 05:55:29
Message-ID: b9bd4af0-73ee-4b71-b540-67eddc6b1ead@v30g2000yqm.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2009-11-07 06:29:13 Re: alter table is taking a long time
Previous Message Joshua Berry 2009-11-07 05:02:20 Re: Absolute value of intervals