Re: Alter table fast
| От | Ron Johnson |
|---|---|
| Тема | Re: Alter table fast |
| Дата | |
| Msg-id | CANzqJaB-k8Sae4st0NP4BW_VuNRP6e1V=f0E7O28URR23MuEww@mail.gmail.com обсуждение исходный текст |
| Ответ на | Alter table fast (veem v <veema0000@gmail.com>) |
| Ответы |
Re: Alter table fast
|
| Список | pgsql-general |
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 по дате отправления: