Re: Adding Column on Huge Table - Mailing list pgsql-admin

From Thomas Kellerer
Subject Re: Adding Column on Huge Table
Date
Msg-id b1cfe8ba-7365-de0d-ba4f-4ca1daeb62f4@gmx.net
Whole thread Raw
In response to Re: Adding Column on Huge Table  (Alex Balashov <abalashov@evaristesys.com>)
List pgsql-admin
Alex Balashov schrieb am 19.03.2019 um 21:52:
> My experience is that adding a column is a rather quick operation even
> on quite large tables, _unless_ the column has a default value, in which
> case that default value is set for every row. In that case, the time
> required for the operation converges with that of a mass-UPDATE.

Which has changed with Postgres 11, where adding a default value does not update all rows in the table.



pgsql-admin by date:

Previous
From: Alex Balashov
Date:
Subject: Re: Adding Column on Huge Table
Next
From: Shreeyansh Dba
Date:
Subject: Re: Adding Column on Huge Table