Re: dealing with lock - Mailing list pgsql-general

Adrian Klaver schrieb am 07.04.2018 um 00:02:
>> Is there a way to identify the list of statements that have to rewrite the table.
> 
> https://www.postgresql.org/docs/10/static/sql-altertable.html
> 
> Notes
> 
> "Adding a column with a DEFAULT clause or changing the type of an existing column will require the entire table and
itsindexes to be rewritten. 
 
Note that this will change with Postgres 11

https://www.depesz.com/2018/04/04/waiting-for-postgresql-11-fast-alter-table-add-column-with-a-non-null-default/