2009/11/7 stanciutheone@xxxxxxxxx <stanciutheone@xxxxxxxxx>: > 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...@xxxxxxxxx" <stanciuthe...@xxxxxxxxx> > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
