Home > mailing lists

Adding New Column with default value. - Mailing list pgsql-admin

From	Gambhir Singh
Subject	Adding New Column with default value.
Date	April 28, 2025 20:24:11
Msg-id	CAHOGQfVmfJ5rpxfMSqJjTZGqN5ss-hdsCdTHsrxHAi2mUwWwmw@mail.gmail.com Whole thread
Responses	Re: Adding New Column with default value. Re: Adding New Column with default value. Re: Adding New Column with default value.
List	pgsql-admin

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 ?

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

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

Thanks & Regards
Gambhir Singh

From: Sbob
Date: 28 April 2025, 17:10:57
Subject: Re: Intermittent missing chunk ERRORS

From: Ron Johnson
Date: 28 April 2025, 20:46:15
Subject: Re: Adding New Column with default value.