Re: Alter table fast

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!