Home Explore Blog CI



postgresql

28th chunk of `doc/src/sgml/ref/create_table.sgml`
5c8d31814bb8c6780b6f9463012411f106e97eaeafdef34a0000000100000fa9
 wraparound) if the <xref linkend="guc-autovacuum"/>
     parameter is false; setting individual tables' storage parameters does
     not override that.  Therefore there is seldom much point in explicitly
     setting this storage parameter to <literal>true</literal>, only
     to <literal>false</literal>.
     </para>
    </listitem>
   </varlistentry>

   <varlistentry id="reloption-vacuum-index-cleanup" xreflabel="vacuum_index_cleanup">
    <term><literal>vacuum_index_cleanup</literal>, <literal>toast.vacuum_index_cleanup</literal> (<type>enum</type>)
    <indexterm>
     <primary><varname>vacuum_index_cleanup</varname> storage parameter</primary>
    </indexterm>
    </term>
    <listitem>
     <para>
      Forces or disables index cleanup when <command>VACUUM</command>
      is run on this table.  The default value is
      <literal>AUTO</literal>.  With <literal>OFF</literal>, index
      cleanup is disabled, with <literal>ON</literal> it is enabled,
      and with <literal>AUTO</literal> a decision is made dynamically,
      each time <command>VACUUM</command> runs.  The dynamic behavior
      allows <command>VACUUM</command> to avoid needlessly scanning
      indexes to remove very few dead tuples.  Forcibly disabling all
      index cleanup can speed up <command>VACUUM</command> very
      significantly, but may also lead to severely bloated indexes if
      table modifications are frequent.  The
      <literal>INDEX_CLEANUP</literal> parameter of <link
       linkend="sql-vacuum"><command>VACUUM</command></link>, if
      specified, overrides the value of this option.
     </para>
    </listitem>
   </varlistentry>

   <varlistentry id="reloption-vacuum-truncate" xreflabel="vacuum_truncate">
    <term><literal>vacuum_truncate</literal>, <literal>toast.vacuum_truncate</literal> (<type>boolean</type>)
    <indexterm>
     <primary><varname>vacuum_truncate</varname> storage parameter</primary>
    </indexterm>
    </term>
    <listitem>
     <para>
      Per-table value for <xref linkend="guc-vacuum-truncate"/> parameter.  The
      <literal>TRUNCATE</literal> parameter of
      <link linkend="sql-vacuum"><command>VACUUM</command></link>, if
      specified, overrides the value of this option.
     </para>
    </listitem>
   </varlistentry>

   <varlistentry id="reloption-autovacuum-vacuum-threshold" xreflabel="autovacuum_vacuum_threshold">
    <term><literal>autovacuum_vacuum_threshold</literal>, <literal>toast.autovacuum_vacuum_threshold</literal> (<type>integer</type>)
    <indexterm>
     <primary><varname>autovacuum_vacuum_threshold</varname></primary>
     <secondary>storage parameter</secondary>
    </indexterm>
    </term>
    <listitem>
     <para>
      Per-table value for <xref linkend="guc-autovacuum-vacuum-threshold"/>
      parameter.
     </para>
    </listitem>
   </varlistentry>

   <varlistentry id="reloption-autovacuum-vacuum-max-threshold" xreflabel="autovacuum_vacuum_max_threshold">
    <term><literal>autovacuum_vacuum_max_threshold</literal>, <literal>toast.autovacuum_vacuum_max_threshold</literal> (<type>integer</type>)
    <indexterm>
     <primary><varname>autovacuum_vacuum_max_threshold</varname></primary>
     <secondary>storage parameter</secondary>
    </indexterm>
    </term>
   <listitem>
    <para>
     Per-table value for <xref linkend="guc-autovacuum-vacuum-max-threshold"/>
     parameter.
    </para>
   </listitem>
  </varlistentry>

   <varlistentry id="reloption-autovacuum-vacuum-scale-factor" xreflabel="autovacuum_vacuum_scale_factor">
    <term><literal>autovacuum_vacuum_scale_factor</literal>, <literal>toast.autovacuum_vacuum_scale_factor</literal> (<type>floating point</type>)
    <indexterm>
     <primary><varname>autovacuum_vacuum_scale_factor</varname> </primary>
     <secondary>storage parameter</secondary>
    </indexterm>
    </term>
    <listitem>
     <para>
      Per-table value for <xref linkend="guc-autovacuum-vacuum-scale-factor"/>
      parameter.
     </para>
    </listitem>

Title: CREATE TABLE Storage Parameters: vacuum_index_cleanup, vacuum_truncate, autovacuum_vacuum_threshold, autovacuum_vacuum_max_threshold, autovacuum_vacuum_scale_factor
Summary
This section details additional storage parameters for the CREATE TABLE command, including 'vacuum_index_cleanup' (controls index cleanup during VACUUM), 'vacuum_truncate' (enables/disables truncation during VACUUM), 'autovacuum_vacuum_threshold' (per-table autovacuum vacuum threshold), 'autovacuum_vacuum_max_threshold' (per-table autovacuum vacuum max threshold), and 'autovacuum_vacuum_scale_factor' (per-table autovacuum vacuum scale factor).