diff options
Diffstat (limited to 'doc/src/sgml/ref/vacuum.sgml')
-rw-r--r-- | doc/src/sgml/ref/vacuum.sgml | 18 |
1 files changed, 16 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/vacuum.sgml b/doc/src/sgml/ref/vacuum.sgml index dd0fbb8cb75..57bc4c23ec0 100644 --- a/doc/src/sgml/ref/vacuum.sgml +++ b/doc/src/sgml/ref/vacuum.sgml @@ -39,7 +39,7 @@ VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ ANALYZE ] [ <replaceable class="paramet PARALLEL <replaceable class="parameter">integer</replaceable> SKIP_DATABASE_STATS [ <replaceable class="parameter">boolean</replaceable> ] ONLY_DATABASE_STATS [ <replaceable class="parameter">boolean</replaceable> ] - BUFFER_USAGE_LIMIT [ <replaceable class="parameter">string</replaceable> ] + BUFFER_USAGE_LIMIT [ <replaceable class="parameter">size</replaceable> ] <phrase>and <replaceable class="parameter">table_and_columns</replaceable> is:</phrase> @@ -364,7 +364,8 @@ VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ ANALYZE ] [ <replaceable class="paramet <xref linkend="guc-vacuum-buffer-usage-limit"/>. Higher settings can allow <command>VACUUM</command> to run more quickly, but having too large a setting may cause too many other useful pages to be evicted from - shared buffers. + shared buffers. The minimum value is <literal>128 kB</literal> and the + maximum value is <literal>16 GB</literal>. </para> </listitem> </varlistentry> @@ -393,6 +394,19 @@ VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ ANALYZE ] [ <replaceable class="paramet </varlistentry> <varlistentry> + <term><replaceable class="parameter">size</replaceable></term> + <listitem> + <para> + Specifies an amount of memory in kilobytes. Sizes may also be specified + as a string containing the numerical size followed by any one of the + following memory units: <literal>kB</literal> (kilobytes), + <literal>MB</literal> (megabytes), <literal>GB</literal> (gigabytes), or + <literal>TB</literal> (terabytes). + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><replaceable class="parameter">table_name</replaceable></term> <listitem> <para> |