diff options
| author | Damian Dimmich <damian@tauri-tec.com> | 2018-11-26 10:47:37 +0400 |
|---|---|---|
| committer | Tim Graham <timograham@gmail.com> | 2018-11-26 09:51:29 -0500 |
| commit | 133e79399a0aeecaca7379dd79cc1cc3f8b5e7ae (patch) | |
| tree | a65226688a34fd862f8e5fc0575e6dc77d14ef35 /docs | |
| parent | 6275b50ac26ea6c026aa7b2aae9192f5792e8a94 (diff) | |
Updated docs for fast column creation with defaults in PostgreSQL 11.
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/topics/migrations.txt | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/docs/topics/migrations.txt b/docs/topics/migrations.txt index 3f0a1fa68c..b44f78cc69 100644 --- a/docs/topics/migrations.txt +++ b/docs/topics/migrations.txt @@ -67,9 +67,10 @@ PostgreSQL ---------- PostgreSQL is the most capable of all the databases here in terms of schema -support; the only caveat is that adding columns with default values will -cause a full rewrite of the table, for a time proportional to its size. +support. +The only caveat is that prior to PostgreSQL 11, adding columns with default +values causes a full rewrite of the table, for a time proportional to its size. For this reason, it's recommended you always create new columns with ``null=True``, as this way they will be added immediately. |