diff options
| author | Bruce Momjian <bruce@momjian.us> | 2010-06-24 14:57:21 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2010-06-24 14:57:21 +0000 |
| commit | f5dc03dc69d70372d4c6d8fe731b570e926085c3 (patch) | |
| tree | db14fe333a5d4a798ebbba08695e973f00c31139 /doc/src | |
| parent | d8cd283a08fe87579e3603eaa8fba4d1eca6a8ca (diff) | |
| download | postgresql-f5dc03dc69d70372d4c6d8fe731b570e926085c3.tar.gz postgresql-f5dc03dc69d70372d4c6d8fe731b570e926085c3.zip | |
Mention that when alter rewrites a table, indexes are also rebuilt.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/alter_table.sgml | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 85f7c75c999..833753aedeb 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.114 2010/06/09 17:48:10 alvherre Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.115 2010/06/24 14:57:21 momjian Exp $ PostgreSQL documentation --> @@ -689,8 +689,8 @@ ALTER TABLE <replaceable class="PARAMETER">name</replaceable> <para> Adding a column with a non-null default or changing the type of an - existing column will require the entire table to be rewritten. This - might take a significant amount of time for a large table; and it will + existing column will require the entire table and indexes to be rewritten. + This might take a significant amount of time for a large table; and it will temporarily require double the disk space. Adding or removing a system <literal>oid</> column likewise requires rewriting the entire table. </para> |