diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/config.sgml | 41 | ||||
| -rw-r--r-- | doc/src/sgml/ref/create_index.sgml | 14 |
2 files changed, 0 insertions, 55 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index ca0d9bd917e..dd2778611f8 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -8349,47 +8349,6 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; </listitem> </varlistentry> - <varlistentry id="guc-vacuum-cleanup-index-scale-factor" xreflabel="vacuum_cleanup_index_scale_factor"> - <term><varname>vacuum_cleanup_index_scale_factor</varname> (<type>floating point</type>) - <indexterm> - <primary><varname>vacuum_cleanup_index_scale_factor</varname></primary> - <secondary>configuration parameter</secondary> - </indexterm> - </term> - <listitem> - <para> - Specifies the fraction of the total number of heap tuples counted in - the previous statistics collection that can be inserted without - incurring an index scan at the <command>VACUUM</command> cleanup stage. - This setting currently applies to B-tree indexes only. - </para> - - <para> - If no tuples were deleted from the heap, B-tree indexes are still - scanned at the <command>VACUUM</command> cleanup stage when at least one - of the following conditions is met: the index statistics are stale, or - the index contains deleted pages that can be recycled during cleanup. - Index statistics are considered to be stale if the number of newly - inserted tuples exceeds the <varname>vacuum_cleanup_index_scale_factor</varname> - fraction of the total number of heap tuples detected by the previous - statistics collection. The total number of heap tuples is stored in - the index meta-page. Note that the meta-page does not include this data - until <command>VACUUM</command> finds no dead tuples, so B-tree index - scan at the cleanup stage can only be skipped if the second and - subsequent <command>VACUUM</command> cycles detect no dead tuples. - </para> - - <para> - The value can range from <literal>0</literal> to - <literal>10000000000</literal>. - When <varname>vacuum_cleanup_index_scale_factor</varname> is set to - <literal>0</literal>, index scans are never skipped during - <command>VACUUM</command> cleanup. The default value is <literal>0.1</literal>. - </para> - - </listitem> - </varlistentry> - <varlistentry id="guc-bytea-output" xreflabel="bytea_output"> <term><varname>bytea_output</varname> (<type>enum</type>) <indexterm> diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml index 3537dfaade6..5a1fd714783 100644 --- a/doc/src/sgml/ref/create_index.sgml +++ b/doc/src/sgml/ref/create_index.sgml @@ -434,20 +434,6 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class= </note> </listitem> </varlistentry> - - <varlistentry id="index-reloption-vacuum-cleanup-index-scale-factor" xreflabel="vacuum_cleanup_index_scale_factor"> - <term><literal>vacuum_cleanup_index_scale_factor</literal> (<type>floating point</type>) - <indexterm> - <primary><varname>vacuum_cleanup_index_scale_factor</varname></primary> - <secondary>storage parameter</secondary> - </indexterm> - </term> - <listitem> - <para> - Per-index value for <xref linkend="guc-vacuum-cleanup-index-scale-factor"/>. - </para> - </listitem> - </varlistentry> </variablelist> <para> |