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 1lKVAL-00024f-Bv for pgsql-docs@arkaria.postgresql.org; Thu, 11 Mar 2021 23:56:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lKV9n-0003ZX-QP for pgsql-docs@arkaria.postgresql.org; Thu, 11 Mar 2021 23:55:55 +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 1lKSxD-0002yW-1X for pgsql-docs@lists.postgresql.org; Thu, 11 Mar 2021 21:34:47 +0000 Received: from sonic306-22.consmr.mail.ne1.yahoo.com ([66.163.189.84]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lKSx9-0004NP-Cg for pgsql-docs@lists.postgresql.org; Thu, 11 Mar 2021 21:34:46 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1615498479; bh=+LYefjERG9XswGsYzHTYU6ZEn/tx6He2PIeENRRwsJ4=; h=From:Subject:To:Cc:References:Date:From:Subject:Reply-To; b=WnEPj6UePchj1mDoIxXdzBmgbLv2ijRKpP6cZ9LDkmllIcxfAIGQOUk6zCzGMx0lZhAnNcwy6/oTUJD0J/5vPP+HVamy968Gw8dWmRLAaDNJ9N5kHxwIq9aUrdTaJVPdS7nHDqUgfa9Pr3TYjjjAF/+R5IERU9qEi6Cg/bq+TV5iAl4IHpNsOTOjISUj+qknLi8ovOjtQ4pWFwOgIUtZcBvl9im6J3SRLI5pMkSu9qXylo1EGYwcMJwm99Y/W93Or8aPHhlN4kMU6FilS+/iyvlnK4R7kC3kSMIUVyxT3fZbcMRvvWtrb7Hk+ZahKEI9GvKBb77domZPRZogWSdasQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1615498479; bh=vxue7xxVeoNLDUyQ47Jij2SsSREhcjXRbiuAWUS3qc8=; h=X-Sonic-MF:From:Subject:To:Date:From:Subject; b=eljzkgzTQ9PWNtEW1ApGYL9QY1VueUxlaAbtx1FTwwANFvSCtPKVEpkJXxhlazHIWHT85I0hlUO6K77AmUhVZ6h1TVKBFXOUci8lhFq8Y1hhlaDeOcyslricxjyKU2T/QHeRPinQfqKxJM4qpcr7JnIOmJeMBtZfrReyMlbYNGPQVna6FmjljdLdzmh6M2+I6UIE68qSmcrtBoJud2PReJ689p/69m3Ndt9DRf9bvgsibn0AEMQQsHdyoURWV/r4Yavayg319bh68HABCzYkKForew6zljvX2gNJrivM4oSV8J3TM7hbFaJhT+WYfZI17WcDjk4Sf3WiyIrX7aOiZw== X-YMail-OSG: ML.sR2oVM1nM8FeJXP_juW9V32YR96HlfneN9aEYqVz2348bO7Brmh40U4HrYW1 MOQ16IQzi83rgGv1QnU5f9F_.GnH1MIJRQbxt9syEIVuf7QG38l14MOn1pWgq_YoXDVXobeOe6UF 4sfqgapkVtWz1dOeIUQ0BUzTZDmQifECOkCaSxxBSTTTw2wGbt_W_v5lMNo1JfobYSFzhl0t4AYZ G5gAShCsRqC0etJKkqvuzK43NgqZbhUCD6YYu2PYsws6ZCslzXPcjeCoMtFcWBsv1Ok0plE.uH.m EsSvNM1PU4o9pLFsCwroODmD0ci9LUCV7IJYJDYEphS.T1glT8180JWdMedMaxWJL77uy08T1lhL BXIOR6zyLVLooa8UmJ_dGJuGriatOSkifBP0fHxB5PSU8SDwVa3a6OPnodKobdHKavlSv34cGY0W 9p.nlLpId_ju4kU5akfEUr8cqpwBl8PgeFRv6.Ju2QS1ldmnvLfts3PdfJmvMBYdBwllaK1fPLyo JLk7PkcMnVfzHgkVbVbZOweCxvmSyyjK06YT9eaEtDXBTS9W_ozarPYmg29DCF7iqYdwYJ.4Cywe Oc.dLZNjDNDY5sOFPjGnJPuejL2E9BwPryAouzbV0fSO9pfDRCAeLt18qisH8cj85kfFf_W1YTak HtM2OJ52mFBHJMcyeG5RymrQUU7aum2Us2lckWp375uA12yb5c.WkdJtkUxkaX.YVrp0QgernWP8 px7H6zSzCl1apEShWV1osVY6StCOBUOLDQNGGKvi8WpGv8yIM7_PIxJ73LmiHdl7Ho7qz4RD6ieR SAp9chCX.1Szcu29hJKWhqm71dSCIQYr_U.XXCoyJeoIkEb1KE8SB7K_UYBXw_v_.u8dxIYTY.kw rBY0bZVmFvzJTTnPmzbkjt1fFUu9LSY.tGLMEr877rtmJ7cJeSXANT41LJRd9U.c89JbopH1yYTH f7fzH8jgvlYrAYC2rhGA1pwAB6llQKpemaCUdl1m5wfLiGnaIv.825iF._aj_UAQQ1sipMX83CFY GH6UTnDatqw9I3JvH0N3S81BznLS0mo04Jy3DpxuHjLG46GDaEQCZpkIAc5yi2TsH5yVwrJz1xs7 zLHBXHZ1jKXkeHIuDnBBzDxry7_dUobPV687CsaNbfBkb7DJjt1uFK31iwZkTpxTVQt8UOOUHGNy fyRQPBy29pdqFqq9caJsNijRXobgXVAh5P9nOnEdMAtI9WD6IaCYI2n9xTL6OKbSFxCCIotjPB0y E7uJe8plAPTRcYQzcv4bnQWdze8IGevgXIPGcPSbKa7nABQDRUbh3HOWt5L2SGureixTyLmkxONc e0pbaro5.yXJFDn0mcS9SA2IxP_IC9iciduPvqfl9ygKZ3KrLY5JCn9_ic0FKOgoWMIjsOO_jcep cHu5k0Qep3QpPNyHuwlN.fm7rKkOuUfLINpaF6iulokhtGQsewPgArEZGgwZViRSVGZR42YWgaOy 0dXs8Bbx8QTdGKFop1I4mL.uk25b9JBqGWifRPA6rkEk2qF1mQt10Ru5eUezX_7DnXVYbeXjjaKR C1mgvvL8zm0Ko8nrzxzTGSLFS49cqkoGb2De1fSRZL1oXzuiFarqtAirDs_d.BFGSr.5.RvMUmJK 31vrcZCEJ6jaBQ24CZ5S23cGfRBLchtvAdpKGikZgFnigyUrwA.z8ozQW_fqBp1CMNBsnz0RyzSU J0vbHW2dxUDgeE4ziatwZUEDJwR0xcC0AkifU0dpSauDPB20r7KKq1bb_Y71kU_t4ViTxR3ocxiC 9fnUirqNJgkpYGx.lofZrbWzswQhH9mb8Lp6SnK2MzwxH6_d5SJQzavkfWDdEDP2q4PM0U4GcWg2 S.6AErMLK_3lpOHJvjiytEDh4eVGPIGPz8SQc2k3ByGKtGVAFltDkLFAcITQziXKpIIdsOxBJJ.R X77fy3qwe0bnvsyLqg1x.5lvMjmz1B0PcQ8mTb9WkZ2huMuGQEB9a1zzqhGfPLMmpxV2lOs7tf9O 4YnxoGYxLEpfWWPtRyT4_g5d7OB9ztIJUsPy5Ud_uaTwKqlUFCCe8NE1Zql9Cu_Zw.JoRowzEgb5 JqWNfLkP8yfgyVSZ6gcgCLbn8i.m5fJeqJqEe_eV2t021I_2nDyAhZ5dXW4pst6wRqeyEx48W0cj NFNL9qDUle9qTd6yi5LM4cPYJDzO2xvnOtNNYr6nsBrlxGR7gMgAwjkg10GOE5oenCfercOHPwpW mBqWlfV5O4Exjc4UfXl1TMZOlQCZ6wXU5xUL9yvypfa7Yg_BNnFqr2ewVLsXxVexvurtmpLTO4mJ tkeV0ln8W3gIUbnTvZDv6_3xHkXIDuUXYwkxHzvDhyN94cEqjjP5Ebn66PwSXhhsRkxy9mnE9O9n wAdZHICea_bCS8HibYpoG9sKg3xI51ReR8fOW.dmaqs6.U2GyK6UtviRlvaQ8zSwKE114CV6B40K i8eWgC7YKHrLC9RZRASMjUraUOfLuDqxsvbgtkk3CwEOiRl8GG.PW_P0vO7VuPhIr9zOrucHb80l vWh6pe7LM08_JZcswmT47ELv2EQ2T16OhCT0Zz0kAcbwfQ_5I4iZKQI9pYA6miD..OE8JwpaPLkX 13fAQbnbE X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic306.consmr.mail.ne1.yahoo.com with HTTP; Thu, 11 Mar 2021 21:34:39 +0000 Received: by smtp419.mail.ir2.yahoo.com (VZM Hermes SMTP Server) with ESMTPA ID 3a7b305f25a70b4720df72825c8ed4d2; Thu, 11 Mar 2021 21:34:34 +0000 (UTC) Content-Type: multipart/alternative; boundary="----sinikael-?=_1-16154984716400.09718703319694821" From: Alex Subject: Re: Invalid idle_in_transaction_session_timeout data type X-Type: replyAll To: Tom Lane Cc: Tatsuo Ishii , pgsql-docs@lists.postgresql.org User-Agent: Desktop Message-Id: References: <11783b8644ae5.7f3aa1e3b18b4.ref@yahoo.com> <11783b8644ae5.7f3aa1e3b18b4@yahoo.com> <20210311.211047.1106690547580793701.t-ishii@gmail.com> <2294219.1615479605@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Thu, 11 Mar 2021 21:34:31 +0000 MIME-Version: 1.0 X-Mailer: WebService/1.1.17927 mail.backend.jedi.jws.acl:role.jedi.acl.token.atz.jws.hermes.yahoo Apache-HttpAsyncClient/4.1.4 (Java/11.0.9.1) Content-Length: 6480 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------sinikael-?=_1-16154984716400.09718703319694821 Content-Type: text/plain; format=flowed Content-Transfer-Encoding: 7bit The following changes would make docs clear: work_mem (numeric with memory unit) statement_timeout (numeric with time unit) ,where "numeric with memory unit" and "numeric with time unit" are links that point to "https://www.postgresql.org/docs/current/config-setting.html" Tom Lane wrote: [ redirecting to pgsql-docs ] Alex > writes: In my opinion, it would be more clear if "Numeric with Unit" would be specified on that property documentation, so that I can search more about what that means (eventually a link pointing to details). I saw "(integer)" so I assumed `show idle_in_transaction_session_timeout ` will return an integer. This complaint isn't totally without merit. I wonder whether there is any value in listing a unit-ized GUC's default unit as part of the type info, so that we'd have entries like work_mem (integer, kilobytes) statement_timeout (integer, milliseconds) That'd both provide some concrete info about which unit applies, and cue unwary users that there might be more to it than just a number. I'm not sure whether this could replace the existing boilerplate phrases about "If this value is specified without units, it is taken as kilobytes", but it's sure more compact. regards, tom lane ------sinikael-?=_1-16154984716400.09718703319694821 Content-Type: text/html; format=flowed Content-Transfer-Encoding: 7bit
The following changes would make docs clear:

work_mem  (numeric with memory unit)

statement_timeout  (numeric with time unit)


,where "numeric with memory unit" and "numeric with time unit" are links that point to "https://www.postgresql.org/docs/current/config-setting.html"


Tom Lane wrote:


[ redirecting to pgsql-docs ]

Alex <cdalxndr@yahoo.com> writes:

In my opinion, it would be more clear if "Numeric with Unit" would be
specified on that property documentation, so that I can search more about
what that means (eventually a link pointing to details).
I saw "(integer)" so I assumed `show idle_in_transaction_session_timeout `

will return an integer.

This complaint isn't totally without merit.  I wonder whether there is
any value in listing a unit-ized GUC's default unit as part of the
type info, so that we'd have entries like

   work_mem  (integer, kilobytes)

   statement_timeout  (integer, milliseconds)

That'd both provide some concrete info about which unit applies,
and cue unwary users that there might be more to it than just a
number.

I'm not sure whether this could replace the existing boilerplate
phrases about "If this value is specified without units, it is taken
as kilobytes", but it's sure more compact.

           regards, tom lane
------sinikael-?=_1-16154984716400.09718703319694821--