Re: Adding New Column with default value.

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Adding New Column with default value.
Date: 2025-04-28 17:46:15
Message-ID: CANzqJaDDCNoLq1E5ZvebwgehN=kFmfsH0f0hmi7tBjwGJR2GTg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Apr 28, 2025 at 1:25 PM Gambhir Singh <gambhir(dot)singh05(at)gmail(dot)com>
wrote:

>
> I got request from app Team to add new column to a table with following
> specifications
>
> 1. With Not Null Constraint
> 2. With Default value 0
>
> Row Count - 50 Billion
>
> Please help me to understand
> a. DDL statement (alter table add column) will be followed by the DML
> statement (Update)....Am I correct ?
>

Do you want existing rows to have a value of 0, or just new ones?

> b. What would be size of the Table (I assuming it will be doubled)
>

It will double if the table currently only has one scalar column.

> c. What is the best approach for this kind of activity.
>

The ALTER TABLE documentation is pretty long, but searching it for
"update", and reading carefully gives pointers.

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2025-04-28 18:34:45 Re: Adding New Column with default value.
Previous Message Gambhir Singh 2025-04-28 17:24:11 Adding New Column with default value.