Hi,

https://www.postgresql.org/docs/current/ddl-alter.html

Tip

Adding a column with a default requires updating each row of the table (to 
store the new column value). However, if no default is specified, PostgreSQL is 
able to avoid the physical update. So if you intend to fill the column with 
mostly nondefault values, it's best to add the column with no default, insert 
the correct values using UPDATE, and then add any desired default as described 
below.

This is not true anymore since PostgreSQL 11, isn't it? If agreed, I would try 
to write my first patch to remove that.

Regards
Daniel

Reply via email to