diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2021-04-09 13:38:07 -0400 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2021-04-09 13:38:07 -0400 |
| commit | 41badeaba8beee7648ebe7923a41c04f1f3cb302 (patch) | |
| tree | f1a1e61fcb03c3ffa8b38e6641cc91c2d6b330ce /doc/src | |
| parent | 0e69f705cc1a3df273b38c9883fb5765991e04fe (diff) | |
| download | postgresql-41badeaba8beee7648ebe7923a41c04f1f3cb302.tar.gz postgresql-41badeaba8beee7648ebe7923a41c04f1f3cb302.zip | |
Document ANALYZE storage parameters for partitioned tables
Commit 0827e8af70f4 added parameters for autovacuum to support
partitioned tables, but didn't add any docs. Add them.
Discussion: https://postgr.es/m/20210408213051.GL6592@telsasoft.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index d7fffddbce3..b6cf9adcb25 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1369,8 +1369,8 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM If a table parameter value is set and the equivalent <literal>toast.</literal> parameter is not, the TOAST table will use the table's parameter value. - Specifying these parameters for partitioned tables is not supported, - but you may specify them for individual leaf partitions. + Except where noted, these parameters are not supported on partitioned + tables; however, you can specify them on individual leaf partitions. </para> <variablelist> @@ -1452,6 +1452,8 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM If true, the autovacuum daemon will perform automatic <command>VACUUM</command> and/or <command>ANALYZE</command> operations on this table following the rules discussed in <xref linkend="autovacuum"/>. + This parameter can be set for partitioned tables to prevent autovacuum + from running <command>ANALYZE</command> on them. If false, this table will not be autovacuumed, except to prevent transaction ID wraparound. See <xref linkend="vacuum-for-wraparound"/> for more about wraparound prevention. @@ -1576,6 +1578,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM <para> Per-table value for <xref linkend="guc-autovacuum-analyze-threshold"/> parameter. + This parameter can be set for partitioned tables. </para> </listitem> </varlistentry> @@ -1591,6 +1594,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM <para> Per-table value for <xref linkend="guc-autovacuum-analyze-scale-factor"/> parameter. + This parameter can be set for partitioned tables. </para> </listitem> </varlistentry> |