postgres.git / summary / log / commit / refs

commit    41badeaba8beee7648ebe7923a41c04f1f3cb302
Author:   Alvaro Herrera <alvherre@alvh.no-ip.org>
Date:     Fri Apr 09 17:38:07 2021 +0000

    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


 doc/src/sgml/ref/create_table.sgml | 8 ++++++--
 1 file 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>


[parent: 0e69f705cc1a]