From: Tom Lane <tgl@sss.pgh.pa.us>
To: Douglas Reed <dougreed765@yahoo.com>
cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>,
        Douglas Reed <douglas@fsbtech.com>
Subject: Re: Problem with Altering a table column
In-reply-to: <825474461.1387396.1576738664403@mail.yahoo.com>
References: <825474461.1387396.1576738664403.ref@mail.yahoo.com>
 <825474461.1387396.1576738664403@mail.yahoo.com>
Comments: In-reply-to Douglas Reed <dougreed765@yahoo.com>
	message dated "Thu, 19 Dec 2019 06:57:44 +0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <7121.1576763323.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Thu, 19 Dec 2019 08:48:43 -0500
Message-ID: <7122.1576763323@sss.pgh.pa.us>
Precedence: bulk

Douglas Reed <dougreed765@yahoo.com> writes:
> I have issued and alter column against the following;
> =C2=A0price_id=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| integer=C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| not null defa=
ult nextval('bet.price_price_id_seq'::regclass) | plain=C2=A0 =C2=A0|=C2=A0=
 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 |
> 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 valida=
tion 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