> On Nov 9, 2021, at 8:02 AM, Avi Weinberg <AviW@xxxxxxxxx> 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
