Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qilJS-007lAa-AX for pgsql-hackers@arkaria.postgresql.org; Wed, 20 Sep 2023 00:43:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qilJQ-00D8KV-MF for pgsql-hackers@arkaria.postgresql.org; Wed, 20 Sep 2023 00:43:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qilJQ-00D8K9-Bz for pgsql-hackers@lists.postgresql.org; Wed, 20 Sep 2023 00:43:28 +0000 Received: from oss.nttdata.com ([49.212.34.109]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qilJK-006DDn-HL for pgsql-hackers@lists.postgresql.org; Wed, 20 Sep 2023 00:43:26 +0000 Received: from oss.nttdata.com (localhost [127.0.0.1]) by oss.nttdata.com (Postfix) with ESMTPA id 8A2DE6077C; Wed, 20 Sep 2023 09:43:15 +0900 (JST) X-Virus-Status: Clean X-Virus-Scanned: clamav-milter 0.103.10 at oss.nttdata.com MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit Date: Wed, 20 Sep 2023 09:43:15 +0900 From: Shinya Kato To: Ryoga Yoshida Cc: pgsql-hackers@lists.postgresql.org Subject: Re: Fix bug in VACUUM and ANALYZE docs In-Reply-To: <9374034cb91b647b55a774a8980b0228@oss.nttdata.com> References: <9374034cb91b647b55a774a8980b0228@oss.nttdata.com> User-Agent: Roundcube Webmail/1.4.11 Message-ID: <9cece9c906c15fc54ee1bcb27ada5b49@oss.nttdata.com> X-Sender: Shinya11.Kato@oss.nttdata.com List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2023-09-19 17:59, Ryoga Yoshida wrote: > 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.html > https://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. Thanks for the patch. You're right. It looks good to me. -- Regards, Shinya Kato NTT DATA GROUP CORPORATION