From: Ryoga Yoshida <bt23yoshidar@oss.nttdata.com>
To: pgsql-hackers@lists.postgresql.org
Subject: Fix bug in VACUUM and ANALYZE docs
Date: Tue, 19 Sep 2023 17:59:11 +0900
Message-ID: <9374034cb91b647b55a774a8980b0228@oss.nttdata.com> (raw)
Hi,
Issue1:
VACUUM and ANALYZE docs explain that the parameter of BUFFER_USAGE_LIMIT
is optional as follows. But this is not true. The argument, size, is
required for BUFFER_USAGE_LIMIT. So the docs should be fixed this issue.
BUFFER_USAGE_LIMIT [ size ]
https://www.postgresql.org/docs/devel/sql-vacuum.htmlhttps://www.postgresql.org/docs/devel/sql-analyze.html
Issue2:
Sizes may also be specified as a string containing the numerical size
followed by any one of the following memory units: kB (kilobytes), MB
(megabytes), GB (gigabytes), or TB (terabytes).
VACUUM and ANALYZE docs explain that the argument of BUFFER_USAGE_LIMIT
accepts the units like kB (kilobytes), MB (megabytes), GB (gigabytes),
or TB (terabytes). But it also actually accepts B(bytes) as an unit. So
the docs should include "B(bytes)" as an unit that the argument of
BUFFER_USAGE_LIMIT can accept.
You can see the patch in the attached file.
Ryoga Yoshida
Attachments:v1-0001-Fix-bug-in-VACUUM-and-ANALYZE-docs.patch (text/x-diff, 2.5K) downloaddiff --git a/doc/src/sgml/ref/analyze.sgml b/doc/src/sgml/ref/analyze.sgmlindex 1fba089265..bc973bdd1e 100644--- a/doc/src/sgml/ref/analyze.sgml+++ b/doc/src/sgml/ref/analyze.sgml@@ -27,7 +27,7 @@ ANALYZE [ ( <replaceable class="parameter">option</replaceable> [, ...] ) ] [ <r
VERBOSE [ <replaceable class="parameter">boolean</replaceable> ]
SKIP_LOCKED [ <replaceable class="parameter">boolean</replaceable> ]
- BUFFER_USAGE_LIMIT [ <replaceable class="parameter">size</replaceable> ]+ BUFFER_USAGE_LIMIT <replaceable class="parameter">size</replaceable>
<phrase>and <replaceable class="parameter">table_and_columns</replaceable> is:</phrase>
@@ -128,7 +128,7 @@ ANALYZE [ ( <replaceable class="parameter">option</replaceable> [, ...] ) ] [ <r
<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),+ following memory units: <literal>B</literal> (bytes), <literal>kB</literal> (kilobytes),
<literal>MB</literal> (megabytes), <literal>GB</literal> (gigabytes), or
<literal>TB</literal> (terabytes).
</para>
diff --git a/doc/src/sgml/ref/vacuum.sgml b/doc/src/sgml/ref/vacuum.sgmlindex 90cde70c07..f2e7c0bbde 100644--- a/doc/src/sgml/ref/vacuum.sgml+++ b/doc/src/sgml/ref/vacuum.sgml@@ -38,7 +38,7 @@ VACUUM [ ( <replaceable class="parameter">option</replaceable> [, ...] ) ] [ <re
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">size</replaceable> ]+ BUFFER_USAGE_LIMIT <replaceable class="parameter">size</replaceable>
<phrase>and <replaceable class="parameter">table_and_columns</replaceable> is:</phrase>
@@ -389,7 +389,7 @@ VACUUM [ ( <replaceable class="parameter">option</replaceable> [, ...] ) ] [ <re
<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),+ following memory units: <literal>B</literal> (bytes), <literal>kB</literal> (kilobytes),
<literal>MB</literal> (megabytes), <literal>GB</literal> (gigabytes), or
<literal>TB</literal> (terabytes).
</para>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: bt23yoshidar@oss.nttdata.com, pgsql-hackers@lists.postgresql.org
Subject: Re: Fix bug in VACUUM and ANALYZE docs
In-Reply-To: <9374034cb91b647b55a774a8980b0228@oss.nttdata.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox