MIME-Version: 1.0
References: <CAB+=1TUcgyKXDKFS-G5GNjJHpP1cHyiXha1pAHc0HG5ZPPu9FQ@mail.gmail.com>
In-Reply-To: <CAB+=1TUcgyKXDKFS-G5GNjJHpP1cHyiXha1pAHc0HG5ZPPu9FQ@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Thu, 9 Jan 2025 11:27:20 -0500
Message-ID: <CANzqJaB-k8Sae4st0NP4BW_VuNRP6e1V=f0E7O28URR23MuEww@mail.gmail.com>
Subject: Re: Alter table fast
To: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000072f68a062b4874af"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaB-k8Sae4st0NP4BW_VuNRP6e1V%3Df0E7O28URR23MuEww%40mail.gmail.com>
Precedence: bulk

--00000000000072f68a062b4874af
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, Jan 9, 2025 at 11:25=E2=80=AFAM veem v <veema0000@gmail.com> wrote:

> Hello,
> It's postgres version 16.1, we want to convert an existing column data
> type from integer to numeric and it's taking a long time. The size of the
> table is ~50GB and the table has ~150million rows in it and it's not
> partitioned. We tried running the direct alter and it's going beyond hour=
s,
> so wanted to understand from experts what is the best way to achieve this=
?
>
>
Out of curiosity, why NUMERIC(15,0) instead of BIGINT?

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--00000000000072f68a062b4874af
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Thu, Jan 9, 2025 at 11:25=E2=80=AFAM v=
eem v &lt;<a href=3D"mailto:veema0000@gmail.com">veema0000@gmail.com</a>&gt=
; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><blockquote =
class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px sol=
id rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Hello, <br>It&#39;s =
postgres version 16.1, we want to convert an existing column data type from=
 integer to numeric and it&#39;s taking a long time. The size of the table =
is ~50GB and the table has ~150million rows in it and it&#39;s not partitio=
ned. We tried running the direct alter and it&#39;s going beyond hours, so =
wanted to understand from experts what is the best way to achieve this?<br>=
</div><div dir=3D"ltr"><br></div></blockquote><div><br></div><div>Out of cu=
riosity, why NUMERIC(15,0) instead of BIGINT?=C2=A0</div></div><div><br></d=
iv><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" cl=
ass=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and but=
ter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Red=
acted&gt; lobster!</div></div></div></div></div></div>

--00000000000072f68a062b4874af--