Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ihpkx-0003M8-ON for pgsql-admin@arkaria.postgresql.org; Thu, 19 Dec 2019 06:57:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ihpkw-0004On-HO for pgsql-admin@arkaria.postgresql.org; Thu, 19 Dec 2019 06:57:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ihpkv-0004DX-Kj for pgsql-admin@lists.postgresql.org; Thu, 19 Dec 2019 06:57:54 +0000 Received: from sonic306-19.consmr.mail.gq1.yahoo.com ([98.137.68.82]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ihpks-00009t-Ud for pgsql-admin@postgresql.org; Thu, 19 Dec 2019 06:57:52 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1576738669; bh=oNQqcVb3ZSddCngPagioJH4MAGIpxGlnCZ6/3jBcjkA=; h=Date:From:Reply-To:To:Cc:Subject:References:From:Subject; b=W0Lht8yjQ2cGHDMcXaKBu5NjJeGAq7U7JPjCo4mAi7s0rNXLibyhW0G2MBpwKghT3JYMQLHTLzQsBNgEb+BFwgCONLQPfR8LnDdS06YOIiCNyxT2WA17jEc32WMp8V4mBPTRhlsf2ob5HzaSmE7fTzkZbj+5ZataxtMWEIXFrOGr0qcH0Xro9heeQTBB3fU1E7vHVQkiM36b8CCfqaq3neoXksRmgyoG7jMS4noMAcHB7mRzw7MByKU4//mniXZCQehvdua6aOkOAaTr3cJXQjZL9ygnJfpsDFyOLs2sr+DKXNAuQKsf+aGzwXvNwqlOlqeMwM6r4B6FrPKkXmYalw== X-YMail-OSG: 5dS4M8sVM1mX.dfCfcv6nWlRp.52coE38P9Oy7o21S8Iuz1yA7DOJxUorIClbrp BRWyMF5rMozJLhyXEPvwoJiDUf72Cr9ArRm73TwA5Xi1akEHVLIZ_10eikiHjWrQNhpImxLxtDf5 1QZXJ.Ti3zeri8OYW2GKmgki88uBFA1UbbRQc.1TYMAGUpfFXUJOJu1NtpdLblA0izngOCECnFWB W_MHwzwYdo2Hm83.6F7c6r2acMWsZyHgQsleZQE4s..hzB_xZVQRLDUyXopGsJZ1it2mVqkDILW6 FDTxreY_7L4OqQV811XfNAjmPCjEhtEciYYMkdMaAYR2881Cqf7d1dcFfyjv.ivAh.xRPmbgcXWZ kUbPrwPMpWDcWXfKhSW.lwS07RMr7zGpbVWKNOq_xjkpoOcAvtXrWhJ6Gh1V22sNEEGouXD5f.eN W3s1aM1vq84rA9ppT3iJRCzTxlnWjFzQwEQ42i80qffC0gd5bDroiKPEIAjRtTOPy2h0HO6xWt1S Gl8K9N0IkRFGWB06Mx5ccrSbyjwvGpk1T4KQ2qAdI9JhexQPmLcOWPt25tlWVT3h4FyYmp0ulP_d LFd6d1hr5Cv4oo.7yGvC6TRXgw3KEybJ93IV1BNKrX53UBThEgYtNdwhF1TqjeERwqkyWQNpB_3z TelTxyY5LDnYs0sRsNDh5p60KdN9xRDDJMensAyVU7nFg4q1FgKvZm8BQXzuympFfqpXGwrYxHQi y2vs0J9oz6ipclhLRtKP756405BY40LqzUoojdZfbqnHuLPVFNEbp58x8iP6eS8q7j3WHcZarbRi FUmgm4zQzhT4KvKY5.bmjMW6aL3mvquQZh3ZpXtW4jZBnIpuwsz1r8v0n0o1_X.avZbsHygn17H. 9SHsBMgLIIB.hnb2tG5DRep2hxnfxUfDAzWiSSHPzGmnEOIlcddwPrmSBuvyiwF_2lle_NyiLQIJ RClF5liqT3DoPY66e2Sn0plWWEJ0f7WIVPc70kh.BVo.B4ctnUIAkOthqGwXahcEvbDXtdvEwonn Rl7oOA6Gqwpq58IZFlKOqhtY_eMJkmBd0fdioXpjISBoCzzCJNl3W7jhpbie9Z0_O8E5EGuIMxQs qlbCqSDbv8Kec41MkhbkQjTUBBDnovf9X6fU9c.DiPwkxA.H99NNLtIlHdHZ1ZUqAO44Lo44QSYy blp31OnlKPYgA82DmfY8EynFTvuxnGnW5TVxLDA.WTHULq7d1Nn4HcpbYF_wfX15XZH9TguZiHA2 48zS6kkaOu999l3jzugqXQWshgKbw.P0v79Djak6QxaZTmHytXn.EqsG4UQw1QWaI2mdgv6SrRzp dYlCavGvaVJgeQ7mxjQHOOWRpdyq4scUsiNmATr4- Received: from sonic.gate.mail.ne1.yahoo.com by sonic306.consmr.mail.gq1.yahoo.com with HTTP; Thu, 19 Dec 2019 06:57:49 +0000 Date: Thu, 19 Dec 2019 06:57:44 +0000 (UTC) From: Douglas Reed Reply-To: Douglas Reed To: "pgsql-admin@postgresql.org" Cc: Douglas Reed Message-ID: <825474461.1387396.1576738664403@mail.yahoo.com> Subject: Problem with Altering a table column MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1387395_1582790022.1576738664402" References: <825474461.1387396.1576738664403.ref@mail.yahoo.com> X-Mailer: WebService/1.1.14873 YMailNorrin Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.88 Safari/537.36 Content-Length: 4167 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_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 Reed=C2=A0dougreed765@yahoo.com=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
Version 9.5

= OS Centos 6 running on a VM
I have a large table (over 10= 0Gb including indexes) 
The machine is slow

I have issued and alter column against the following;

 price_id         | integer&nbs= p;                    | n= ot null default nextval('bet.price_price_id_seq'::regclass) | plain  &= nbsp;|              |

As;

ALTER TABLE bet.price ALTER COLUMN price_id TYPE bigint;

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

It now seems to have gone quie= t (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?

- = Is it safe to terminate the process?

Many thanks




Doug Reed 
dougreed765@yahoo.com 
07973-132664
https://uk.linkedin.com/pub/douglas-reed/33/326/2b
<= /div> ------=_Part_1387395_1582790022.1576738664402--