Problem with Altering a table column
Douglas Reed <[email protected]> Thu, 19 Dec 2019 06:57:44 +0000 (UTC)
| Newsgroups | gmane.comp.db.postgresql.admin |
|---|---|
| Message-ID | <[email protected]> |
------=_Part_1387395_1582790022.1576738664402
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Version 9.5
OS Centos 6 running on a VM
I have a large table (over 100Gb including indexes)=C2=A0
The machine is slow
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 defau=
lt 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 |
As;
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 ta=
ble 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 validatio=
n etc?
- Is it safe to terminate the process?
Many thanks
Doug [email protected]=C2=A007973-132664https://uk.linkedin.c=
om/pub/douglas-reed/33/326/2b
------=_Part_1387395_1582790022.1576738664402
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
<html><head></head><body><div class=3D"ydp93694109yahoo-style-wrap" style=
=3D"font-family: Helvetica Neue, Helvetica, Arial, sans-serif; font-size: 1=
3px;"><div dir=3D"ltr" data-setdir=3D"false">Version 9.5</div><div dir=3D"l=
tr" data-setdir=3D"false"><br></div><div dir=3D"ltr" data-setdir=3D"false">=
OS Centos 6 running on a VM</div><div dir=3D"ltr" data-setdir=3D"false"><br=
></div><div dir=3D"ltr" data-setdir=3D"false">I have a large table (over 10=
0Gb including indexes) </div><div dir=3D"ltr" data-setdir=3D"false"><b=
r></div><div dir=3D"ltr" data-setdir=3D"false">The machine is slow</div><di=
v dir=3D"ltr" data-setdir=3D"false"><br></div><div dir=3D"ltr" data-setdir=
=3D"false">I have issued and alter column against the following;</div><div =
dir=3D"ltr" data-setdir=3D"false"><br></div><div dir=3D"ltr" data-setdir=3D=
"false"><span> price_id | integer&nbs=
p; | n=
ot null default nextval('bet.price_price_id_seq'::regclass) | plain &=
nbsp;| |</span><br></div><d=
iv dir=3D"ltr" data-setdir=3D"false"><span><br></span></div><div dir=3D"ltr=
" data-setdir=3D"false"><span>As;</span></div><div dir=3D"ltr" data-setdir=
=3D"false"><span><br></span></div><div dir=3D"ltr" data-setdir=3D"false"><s=
pan><span>ALTER TABLE bet.price ALTER COLUMN price_id TYPE bigint;</span><b=
r></span></div><div dir=3D"ltr" data-setdir=3D"false"><span><span><br></spa=
n></span></div><div dir=3D"ltr" data-setdir=3D"false"><span><span>The proce=
ss 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</span></span></div><div d=
ir=3D"ltr" data-setdir=3D"false"><span><span><br></span></span></div><div d=
ir=3D"ltr" data-setdir=3D"false"><span><span>It now seems to have gone quie=
t (no temp disk files etc), it still seems to be clicking up CPU</span></sp=
an></div><div dir=3D"ltr" data-setdir=3D"false"><span><span><br></span></sp=
an></div><div dir=3D"ltr" data-setdir=3D"false">- Is there a final part of =
the process where it may just be doing validation etc?</div><div dir=3D"ltr=
" data-setdir=3D"false"><br></div><div dir=3D"ltr" data-setdir=3D"false">- =
Is it safe to terminate the process?</div><div dir=3D"ltr" data-setdir=3D"f=
alse"><br></div><div dir=3D"ltr" data-setdir=3D"false">Many thanks</div><di=
v><br></div><div><br></div><div><br></div><div><br></div><div class=3D"ydp9=
3694109signature">Doug Reed <div>[email protected] </div><div=
>07973-132664</div><div><span style=3D"color:rgb(51, 51, 51);font-family:Ar=
ial, sans-serif;font-size:11px;line-height:17px;background-color:rgb(246, 2=
46, 246);">https://uk.linkedin.com/pub/douglas-reed/33/326/2b</span></div><=
/div></div></body></html>
------=_Part_1387395_1582790022.1576738664402--