> On Nov 9, 2021, at 8:02 AM, Avi Weinberg <a...@gilat.com> wrote:
>
> • A third column is added to table with default value on publisher
> side, but without default value on subscriber side
> • The default value column has value for existing rows on publisher,
> but null on the subscriber side.
See https://www.postgresql.org/docs/14/ddl-alter.html#DDL-ALTER-ADDING-A-COLUMN
The important part is this TIP:
From PostgreSQL 11, adding a column with a constant default value no longer
means that each row of the table needs to be updated when the ALTER TABLE
statement is executed. Instead, the default value will be returned the next
time the row is accessed, and applied when the table is rewritten, making the
ALTER TABLE very fast even on large tables.
—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
