From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Douglas Reed <dougreed765(at)yahoo(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, Douglas Reed <douglas(at)fsbtech(dot)com> |
Subject: | Re: Problem with Altering a table column |
Date: | 2019-12-19 13:48:43 |
Message-ID: | 7122.1576763323@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Douglas Reed <dougreed765(at)yahoo(dot)com> writes:
> I have issued and alter column against the following;
> price_id | integer | not null default nextval('bet.price_price_id_seq'::regclass) | plain | |
> ALTER TABLE bet.price ALTER COLUMN price_id TYPE bigint;
> The process has taken a very long time, I know that it is rebuilding the table and a lot of temp files have been created, deleted etc
> It now seems to have gone quiet (no temp disk files etc), it still seems to be clicking up CPU
> - Is there a final part of the process where it may just be doing validation etc?
Foreign key revalidation maybe ... does this column participate in any
foreign keys?
> - Is it safe to terminate the process?
Yeah, but you'd lose all the work done so far.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2019-12-19 13:55:13 | Re: Query planning around one key of a multi-column index |
Previous Message | bw | 2019-12-19 12:12:25 | Re: backup script error with could not connect to database |