Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oxveJ-0000tX-Es for pgsql-docs@arkaria.postgresql.org; Wed, 23 Nov 2022 19:43:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oxveH-0003BR-Fj for pgsql-docs@arkaria.postgresql.org; Wed, 23 Nov 2022 19:43:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oxveH-0003B5-7g for pgsql-docs@lists.postgresql.org; Wed, 23 Nov 2022 19:43:09 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oxveE-0001tu-M5 for pgsql-docs@lists.postgresql.org; Wed, 23 Nov 2022 19:43:08 +0000 Received: from bruce by momjian.us with local (Exim 4.94.2) (envelope-from ) id 1oxveB-00AwB1-Ij; Wed, 23 Nov 2022 14:43:03 -0500 Date: Wed, 23 Nov 2022 14:43:03 -0500 From: Bruce Momjian To: iphatiey5eu2au6@pasms.be, pgsql-docs@lists.postgresql.org Subject: Re: temporary file size clarification Message-ID: References: <166859439833.632.13122583000472281400@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <166859439833.632.13122583000472281400@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Nov 16, 2022 at 10:26:38AM +0000, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/14/runtime-config-logging.html > Description: > > The setting log_temp_files will enable logging of the usage of temporary > files, including their size in the log files. The setting is given in > kilobytes, which is clearly documented. However, I could not find any clear > documentation that describes the unit of size that is used in the logfiles > themselves, the log line is something like "profiles@profiles LOG: > temporary file: path "base/pgsql_tmp/pgsql_tmp31863.1", size 3137536" but > there is no size unit in the logfile or in the settings documentation. Can > you add whether the log line is in bytes/kilobytes/megabytes? Uh, I believe it is simply in bytes. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Indecision is a decision. Inaction is an action. Mark Batterson