4 ms·
Statement about default value for new column is not actual anymore starting from Postgres 11 https://www.depesz.com/2018/04/04/waiting-for-postgresql-11-fast-a
by hyzyla 5y ago
Statement about default value for new column is not actual anymore starting from Postgres 11
https://www.depesz.com/2018/04/04/waiting-for-postgresql-11-fast-alter-table-add-column-with-a-non-null-default/ https://www.depesz.com/2018/04/04/waiting-for-postgresql-11-...
- saisrirampur 5y agoThat is right.. default value for new column is now pretty fast.. all the other 6 tips are current and very relevant.. this blog has been my goto blog for debugging locks in postgres, as it captures a very crisp summary on this topic!
- philliphaydon 5y agoJust checked. Article was written Feb 2018, and pg11 was released in October 2018. This was one of the huge features I was excited about when it dropped!