| 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!
| 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. |