diff options
| author | Simon Riggs <simon@2ndQuadrant.com> | 2017-03-06 16:48:12 +0530 |
|---|---|---|
| committer | Simon Riggs <simon@2ndQuadrant.com> | 2017-03-06 16:48:12 +0530 |
| commit | 6f3a13ff058f15d565a30c16c0c2cb14cc994e42 (patch) | |
| tree | 1973c8a5dc8a3d60843e0d6627f0af769c34d3ae | |
| parent | 21d4e2e20656381b4652eb675af4f6d65053607f (diff) | |
| download | postgresql-6f3a13ff058f15d565a30c16c0c2cb14cc994e42.tar.gz postgresql-6f3a13ff058f15d565a30c16c0c2cb14cc994e42.zip | |
Enhance docs for ALTER TABLE lock levels of storage parms
As requested by Robert Haas
| -rw-r--r-- | doc/src/sgml/ref/alter_table.sgml | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index da431f8369a..8b251f9e5d7 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -568,10 +568,17 @@ ALTER TABLE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> That can be done with <link linkend="SQL-VACUUM">VACUUM FULL</>, <xref linkend="SQL-CLUSTER"> or one of the forms of <command>ALTER TABLE</> that forces a table rewrite. + For planner related parameters, changes will take effect from the next + time the table is locked so currently executing queries will not be + affected. </para> <para> - Changing fillfactor and autovacuum storage parameters acquires a <literal>SHARE UPDATE EXCLUSIVE</literal> lock. + <literal>SHARE UPDATE EXCLUSIVE</literal> lock will be taken for + fillfactor and autovacuum storage parameters, as well as the + following planner related parameters: + effective_io_concurrency, parallel_workers, seq_page_cost + random_page_cost, n_distinct and n_distinct_inherited. </para> <note> |