Request a Demo
Home   >   mailing lists

Re: Alter table fast - Mailing list pgsql-general

From Ron Johnson
Subject Re: Alter table fast
Date
Msg-id CANzqJaB-k8Sae4st0NP4BW_VuNRP6e1V=f0E7O28URR23MuEww@mail.gmail.com
Whole thread Raw
In response to Alter table fast  (veem v <veema0000@gmail.com>)
Responses Re: Alter table fast
List pgsql-general
Tree view
On Thu, Jan 9, 2025 at 11:25 AM 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 hours, so wanted to understand from experts what is the best way to achieve this?


Out of curiosity, why NUMERIC(15,0) instead of BIGINT? 

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

pgsql-general by date:

Previous
From: veem v
Date:
Subject: Alter table fast
Next
From: yudhi s
Date:
Subject: recovery error while running any statement