The relevant bit from your first link: "postgres will update the table structure and there is no locking unless you do something that needs to alter existing ro

The relevant bit from your first link: "postgres will update the table structure and there is no locking unless you do something that needs to alter existing rows." So, altering a column (e.g. adding a default) will trigger the problem. Adding a new column or table will not.