On Thu, Jan 9, 2025 at 11:25 AM veem v <veema0...@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!
