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 1lKbFi-0008PQ-Sf for pgsql-docs@arkaria.postgresql.org; Fri, 12 Mar 2021 06:26:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lKbFh-0004Nf-R5 for pgsql-docs@arkaria.postgresql.org; Fri, 12 Mar 2021 06:26:25 +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 1lKbFh-0004NS-Lx for pgsql-docs@lists.postgresql.org; Fri, 12 Mar 2021 06:26:25 +0000 Received: from relay10.mail.gandi.net ([217.70.178.230]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lKbFf-00007B-EE for pgsql-docs@lists.postgresql.org; Fri, 12 Mar 2021 06:26:25 +0000 Received: from [172.16.255.146] (14.149.88.79.rev.sfr.net [79.88.149.14]) (Authenticated sender: vik@postgresfriends.org) by relay10.mail.gandi.net (Postfix) with ESMTPSA id 43459240002; Fri, 12 Mar 2021 06:26:19 +0000 (UTC) Subject: Re: Invalid idle_in_transaction_session_timeout data type To: Tom Lane , Alex Cc: Tatsuo Ishii , pgsql-docs@lists.postgresql.org References: <11783b8644ae5.7f3aa1e3b18b4.ref@yahoo.com> <11783b8644ae5.7f3aa1e3b18b4@yahoo.com> <20210311.211047.1106690547580793701.t-ishii@gmail.com> <2294219.1615479605@sss.pgh.pa.us> <2406383.1615513844@sss.pgh.pa.us> From: Vik Fearing Message-ID: <8ea2c5ee-d2ad-e32c-3c49-5fa77b9090f2@postgresfriends.org> Date: Fri, 12 Mar 2021 07:26:19 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 In-Reply-To: <2406383.1615513844@sss.pgh.pa.us> Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 3/12/21 2:50 AM, Tom Lane wrote: > Alex writes: >> The following changes would make docs clear: >> work_mem (numeric with memory unit) >> statement_timeout (numeric with time unit) > > I'm not sure about "clear", but I am sure that'd be inaccurate. > We have integer GUCs and float8 GUCs, but no numeric GUCs. > I do not see a useful purpose in obscuring that distinction. > > I could see using a couple more words than I suggested before: > > work_mem (integer, units of kilobytes) This gets a little more complicated with: shared_buffers (integer, units of BLOCKSZ) -- Vik Fearing