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 1pTzuT-0000IE-RC for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Feb 2023 06:44: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 1pTzuS-0004p3-Mx for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Feb 2023 06:44:24 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pTzuR-0004os-MJ for pgsql-hackers@lists.postgresql.org; Mon, 20 Feb 2023 06:44:24 +0000 Received: from new2-smtp.messagingengine.com ([66.111.4.224]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pTzuN-0002Bu-Ry for pgsql-hackers@postgresql.org; Mon, 20 Feb 2023 06:44:22 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailnew.nyi.internal (Postfix) with ESMTP id EE4E858204B for ; Mon, 20 Feb 2023 01:44:17 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Mon, 20 Feb 2023 01:44:17 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:date:feedback-id :feedback-id:from:from:in-reply-to:message-id:mime-version :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1676875457; x= 1676882657; bh=wF6GszbFIp5WMgVBANeppVwumqMPoZFgFphTJaPieXU=; b=a mIIFGH2jHrOyt70jCLr0AMw1gQvTgPc2frPxznFu1gS1HZ7hz8j37b8udPEy5QRe fsL2ws2s1dx2ukRiEMRnYiUyMqUbM2RxBvejyFCI1NG0LsMWoiuzm1x3DMxT4zyt K6mFbpQwpPL3stMO4Y7AWPWKz3fZfIqrRjHTE3o00D6EXtbdm3iiWFfVrokHPGEE 9egB2DH+csl8x/DLQ1hpHZ+++cHUA09Ae1EuoJ9/tpFbnXRaGMF3VuvI+RrOidk/ 8w0pEkl5TWLr0Wi/TvwSbNhhmRlQ0RBbO6lWBvQeRIq1fFF6F/48cy4BcDSDb9MS +UG5Ghr9XrJrmJyrW6aKw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrudejgedgleeiucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucenucfjughrpegtkfffgggfhffuvfesmhdtreertd efjeenucfhrhhomheprfgvthgvrhcugfhishgvnhhtrhgruhhtuceophgvthgvrhdrvghi shgvnhhtrhgruhhtsegvnhhtvghrphhrihhsvggusgdrtghomheqnecuggftrfgrthhtvg hrnhepteevuedvieekieeghfevfffhhfdvjeevleelfeeikeeikedvffegteekuddtfeel necuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepphgvth gvrhdrvghishgvnhhtrhgruhhtsegvnhhtvghrphhrihhsvggusgdrtghomh X-ME-Proxy: Feedback-ID: i131946ab:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA for ; Mon, 20 Feb 2023 01:44:17 -0500 (EST) Content-Type: multipart/mixed; boundary="------------qIqcRUaJV5rz1GoLPVnJ3Gwf" Message-ID: <0106914a-9eb5-22be-40d8-652cc88c827d@enterprisedb.com> Date: Mon, 20 Feb 2023 07:44:15 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.6.1 Content-Language: en-US From: Peter Eisentraut Subject: Add support for unit "B" to pg_size_pretty() To: pgsql-hackers List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------qIqcRUaJV5rz1GoLPVnJ3Gwf Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit This patch adds support for the unit "B" to pg_size_pretty(). This makes it consistent with the units support in GUC. (pg_size_pretty() only supports "bytes", but GUC only supports "B". -- I opted against adding support for "bytes" to GUC.) --------------qIqcRUaJV5rz1GoLPVnJ3Gwf Content-Type: text/plain; charset=UTF-8; name="0001-Add-support-for-unit-B-to-pg_size_pretty.patch" Content-Disposition: attachment; filename="0001-Add-support-for-unit-B-to-pg_size_pretty.patch" Content-Transfer-Encoding: base64 RnJvbSA2MDVhZGE4ZGMzOGIzNWFhNzBhMjgxYTdjYWNhYjY1Y2U4OWY0MmJlIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBQZXRlciBFaXNlbnRyYXV0IDxwZXRlckBlaXNlbnRy YXV0Lm9yZz4KRGF0ZTogTW9uLCAyMCBGZWIgMjAyMyAwNzozNjoyOCArMDEwMApTdWJqZWN0 OiBbUEFUQ0hdIEFkZCBzdXBwb3J0IGZvciB1bml0ICJCIiB0byBwZ19zaXplX3ByZXR0eSgp CgpUaGlzIG1ha2VzIGl0IGNvbnNpc3RlbnQgd2l0aCB0aGUgdW5pdHMgc3VwcG9ydCBpbiBH VUMuCi0tLQogZG9jL3NyYy9zZ21sL2Z1bmMuc2dtbCAgICAgICAgICAgICAgIHwgIDIgKy0K IHNyYy9iYWNrZW5kL3V0aWxzL2FkdC9kYnNpemUuYyAgICAgICB8ICAzICsrLQogc3JjL3Rl c3QvcmVncmVzcy9leHBlY3RlZC9kYnNpemUub3V0IHwgMTUgKysrKysrKystLS0tLS0tCiBz cmMvdGVzdC9yZWdyZXNzL3NxbC9kYnNpemUuc3FsICAgICAgfCAgMiArLQogNCBmaWxlcyBj aGFuZ2VkLCAxMiBpbnNlcnRpb25zKCspLCAxMCBkZWxldGlvbnMoLSkKCmRpZmYgLS1naXQg YS9kb2Mvc3JjL3NnbWwvZnVuYy5zZ21sIGIvZG9jL3NyYy9zZ21sL2Z1bmMuc2dtbAppbmRl eCBlMDllMjg5YTQzLi4xNWE1YTk4YjBhIDEwMDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwvZnVu Yy5zZ21sCisrKyBiL2RvYy9zcmMvc2dtbC9mdW5jLnNnbWwKQEAgLTI3MTYyLDcgKzI3MTYy LDcgQEAgPHRpdGxlPkRhdGFiYXNlIE9iamVjdCBTaXplIEZ1bmN0aW9uczwvdGl0bGU+CiAg ICAgICAgPC9wYXJhPgogICAgICAgIDxwYXJhPgogICAgICAgICBDb252ZXJ0cyBhIHNpemUg aW4gYnl0ZXMgaW50byBhIG1vcmUgZWFzaWx5IGh1bWFuLXJlYWRhYmxlIGZvcm1hdCB3aXRo Ci0gICAgICAgIHNpemUgdW5pdHMgKGJ5dGVzLCBrQiwgTUIsIEdCIG9yIFRCIGFzIGFwcHJv cHJpYXRlKS4gIE5vdGUgdGhhdCB0aGUKKyAgICAgICAgc2l6ZSB1bml0cyAoYnl0ZXMsIEIs IGtCLCBNQiwgR0Igb3IgVEIgYXMgYXBwcm9wcmlhdGUpLiAgTm90ZSB0aGF0IHRoZQogICAg ICAgICB1bml0cyBhcmUgcG93ZXJzIG9mIDIgcmF0aGVyIHRoYW4gcG93ZXJzIG9mIDEwLCBz byAxa0IgaXMgMTAyNCBieXRlcywKICAgICAgICAgMU1CIGlzIDEwMjQ8c3VwZXJzY3JpcHQ+ Mjwvc3VwZXJzY3JpcHQ+ID0gMTA0ODU3NiBieXRlcywgYW5kIHNvIG9uLgogICAgICAgIDwv cGFyYT48L2VudHJ5PgpkaWZmIC0tZ2l0IGEvc3JjL2JhY2tlbmQvdXRpbHMvYWR0L2Ric2l6 ZS5jIGIvc3JjL2JhY2tlbmQvdXRpbHMvYWR0L2Ric2l6ZS5jCmluZGV4IGRiZDQwNDEwMWYu LjllY2Q1NDI4YzMgMTAwNjQ0Ci0tLSBhL3NyYy9iYWNrZW5kL3V0aWxzL2FkdC9kYnNpemUu YworKysgYi9zcmMvYmFja2VuZC91dGlscy9hZHQvZGJzaXplLmMKQEAgLTQ5LDYgKzQ5LDcg QEAgc3RydWN0IHNpemVfcHJldHR5X3VuaXQKIC8qIFdoZW4gYWRkaW5nIHVuaXRzIGhlcmUg YWxzbyB1cGRhdGUgdGhlIGVycm9yIG1lc3NhZ2UgaW4gcGdfc2l6ZV9ieXRlcyAqLwogc3Rh dGljIGNvbnN0IHN0cnVjdCBzaXplX3ByZXR0eV91bml0IHNpemVfcHJldHR5X3VuaXRzW10g PSB7CiAJeyJieXRlcyIsIDEwICogMTAyNCwgZmFsc2UsIDB9LAorCXsiQiIsIDEwICogMTAy NCwgZmFsc2UsIDB9LAogCXsia0IiLCAyMCAqIDEwMjQgLSAxLCB0cnVlLCAxMH0sCiAJeyJN QiIsIDIwICogMTAyNCAtIDEsIHRydWUsIDIwfSwKIAl7IkdCIiwgMjAgKiAxMDI0IC0gMSwg dHJ1ZSwgMzB9LApAQCAtODEzLDcgKzgxNCw3IEBAIHBnX3NpemVfYnl0ZXMoUEdfRlVOQ1RJ T05fQVJHUykKIAkJCQkJKGVycmNvZGUoRVJSQ09ERV9JTlZBTElEX1BBUkFNRVRFUl9WQUxV RSksCiAJCQkJCSBlcnJtc2coImludmFsaWQgc2l6ZTogXCIlc1wiIiwgdGV4dF90b19jc3Ry aW5nKGFyZykpLAogCQkJCQkgZXJyZGV0YWlsKCJJbnZhbGlkIHNpemUgdW5pdDogXCIlc1wi LiIsIHN0cnB0ciksCi0JCQkJCSBlcnJoaW50KCJWYWxpZCB1bml0cyBhcmUgXCJieXRlc1wi LCBcImtCXCIsIFwiTUJcIiwgXCJHQlwiLCBcIlRCXCIsIGFuZCBcIlBCXCIuIikpKTsKKwkJ CQkJIGVycmhpbnQoIlZhbGlkIHVuaXRzIGFyZSBcImJ5dGVzXCIsIFwiQlwiLCBcImtCXCIs IFwiTUJcIiwgXCJHQlwiLCBcIlRCXCIsIGFuZCBcIlBCXCIuIikpKTsKIAogCQlpZiAobXVs dGlwbGllciA+IDEpCiAJCXsKZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0 ZWQvZGJzaXplLm91dCBiL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvZGJzaXplLm91dApp bmRleCBkOGQ2Njg2YjVmLi5mMTEyMWE4N2FhIDEwMDY0NAotLS0gYS9zcmMvdGVzdC9yZWdy ZXNzL2V4cGVjdGVkL2Ric2l6ZS5vdXQKKysrIGIvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3Rl ZC9kYnNpemUub3V0CkBAIC04MSwxMiArODEsMTMgQEAgU0VMRUNUIHNpemUsIHBnX3NpemVf cHJldHR5KHNpemUpLCBwZ19zaXplX3ByZXR0eSgtMSAqIHNpemUpIEZST00KIAogLS0gcGdf c2l6ZV9ieXRlcygpIHRlc3RzCiBTRUxFQ1Qgc2l6ZSwgcGdfc2l6ZV9ieXRlcyhzaXplKSBG Uk9NCi0gICAgKFZBTFVFUyAoJzEnKSwgKCcxMjNieXRlcycpLCAoJzFrQicpLCAoJzFNQicp LCAoJyAxIEdCJyksICgnMS41IEdCICcpLAorICAgIChWQUxVRVMgKCcxJyksICgnMTIzYnl0 ZXMnKSwgKCcyNTYgQicpLCAoJzFrQicpLCAoJzFNQicpLCAoJyAxIEdCJyksICgnMS41IEdC ICcpLAogICAgICAgICAgICAgKCcxVEInKSwgKCczMDAwIFRCJyksICgnMWU2IE1CJyksICgn OTkgUEInKSkgeChzaXplKTsKICAgIHNpemUgICB8ICAgcGdfc2l6ZV9ieXRlcyAgICAKIC0t LS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0KICAxICAgICAgICB8ICAgICAgICAgICAg ICAgICAgMQogIDEyM2J5dGVzIHwgICAgICAgICAgICAgICAgMTIzCisgMjU2IEIgICAgfCAg ICAgICAgICAgICAgICAyNTYKICAxa0IgICAgICB8ICAgICAgICAgICAgICAgMTAyNAogIDFN QiAgICAgIHwgICAgICAgICAgICAxMDQ4NTc2CiAgIDEgR0IgICAgfCAgICAgICAgIDEwNzM3 NDE4MjQKQEAgLTk1LDcgKzk2LDcgQEAgU0VMRUNUIHNpemUsIHBnX3NpemVfYnl0ZXMoc2l6 ZSkgRlJPTQogIDMwMDAgVEIgIHwgICAzMjk4NTM0ODgzMzI4MDAwCiAgMWU2IE1CICAgfCAg ICAgIDEwNDg1NzYwMDAwMDAKICA5OSBQQiAgICB8IDExMTQ2NDA5MDc3NzQxOTc3NgotKDEw IHJvd3MpCisoMTEgcm93cykKIAogLS0gY2FzZS1pbnNlbnNpdGl2ZSB1bml0cyBhcmUgc3Vw cG9ydGVkCiBTRUxFQ1Qgc2l6ZSwgcGdfc2l6ZV9ieXRlcyhzaXplKSBGUk9NCkBAIC0xNTMs MTUgKzE1NCwxNSBAQCBTRUxFQ1Qgc2l6ZSwgcGdfc2l6ZV9ieXRlcyhzaXplKSBGUk9NCiBT RUxFQ1QgcGdfc2l6ZV9ieXRlcygnMSBBQicpOwogRVJST1I6ICBpbnZhbGlkIHNpemU6ICIx IEFCIgogREVUQUlMOiAgSW52YWxpZCBzaXplIHVuaXQ6ICJBQiIuCi1ISU5UOiAgVmFsaWQg dW5pdHMgYXJlICJieXRlcyIsICJrQiIsICJNQiIsICJHQiIsICJUQiIsIGFuZCAiUEIiLgor SElOVDogIFZhbGlkIHVuaXRzIGFyZSAiYnl0ZXMiLCAiQiIsICJrQiIsICJNQiIsICJHQiIs ICJUQiIsIGFuZCAiUEIiLgogU0VMRUNUIHBnX3NpemVfYnl0ZXMoJzEgQUIgQScpOwogRVJS T1I6ICBpbnZhbGlkIHNpemU6ICIxIEFCIEEiCiBERVRBSUw6ICBJbnZhbGlkIHNpemUgdW5p dDogIkFCIEEiLgotSElOVDogIFZhbGlkIHVuaXRzIGFyZSAiYnl0ZXMiLCAia0IiLCAiTUIi LCAiR0IiLCAiVEIiLCBhbmQgIlBCIi4KK0hJTlQ6ICBWYWxpZCB1bml0cyBhcmUgImJ5dGVz IiwgIkIiLCAia0IiLCAiTUIiLCAiR0IiLCAiVEIiLCBhbmQgIlBCIi4KIFNFTEVDVCBwZ19z aXplX2J5dGVzKCcxIEFCIEEgICAgJyk7CiBFUlJPUjogIGludmFsaWQgc2l6ZTogIjEgQUIg QSAgICAiCiBERVRBSUw6ICBJbnZhbGlkIHNpemUgdW5pdDogIkFCIEEiLgotSElOVDogIFZh bGlkIHVuaXRzIGFyZSAiYnl0ZXMiLCAia0IiLCAiTUIiLCAiR0IiLCAiVEIiLCBhbmQgIlBC Ii4KK0hJTlQ6ICBWYWxpZCB1bml0cyBhcmUgImJ5dGVzIiwgIkIiLCAia0IiLCAiTUIiLCAi R0IiLCAiVEIiLCBhbmQgIlBCIi4KIFNFTEVDVCBwZ19zaXplX2J5dGVzKCc5MjIzMzcyMDM2 ODU0Nzc1ODA3LjknKTsKIEVSUk9SOiAgYmlnaW50IG91dCBvZiByYW5nZQogU0VMRUNUIHBn X3NpemVfYnl0ZXMoJzFlMTAwJyk7CkBAIC0xNzEsNyArMTcyLDcgQEAgRVJST1I6ICB2YWx1 ZSBvdmVyZmxvd3MgbnVtZXJpYyBmb3JtYXQKIFNFTEVDVCBwZ19zaXplX2J5dGVzKCcxIGJ5 dGUnKTsgIC0tIHRoZSBzaW5ndWxhciAiYnl0ZSIgaXMgbm90IHN1cHBvcnRlZAogRVJST1I6 ICBpbnZhbGlkIHNpemU6ICIxIGJ5dGUiCiBERVRBSUw6ICBJbnZhbGlkIHNpemUgdW5pdDog ImJ5dGUiLgotSElOVDogIFZhbGlkIHVuaXRzIGFyZSAiYnl0ZXMiLCAia0IiLCAiTUIiLCAi R0IiLCAiVEIiLCBhbmQgIlBCIi4KK0hJTlQ6ICBWYWxpZCB1bml0cyBhcmUgImJ5dGVzIiwg IkIiLCAia0IiLCAiTUIiLCAiR0IiLCAiVEIiLCBhbmQgIlBCIi4KIFNFTEVDVCBwZ19zaXpl X2J5dGVzKCcnKTsKIEVSUk9SOiAgaW52YWxpZCBzaXplOiAiIgogU0VMRUNUIHBnX3NpemVf Ynl0ZXMoJ2tiJyk7CkBAIC0xODksNiArMTkwLDYgQEAgRVJST1I6ICBpbnZhbGlkIHNpemU6 ICIuKzkxMiIKIFNFTEVDVCBwZ19zaXplX2J5dGVzKCcrOTEyKyBrQicpOwogRVJST1I6ICBp bnZhbGlkIHNpemU6ICIrOTEyKyBrQiIKIERFVEFJTDogIEludmFsaWQgc2l6ZSB1bml0OiAi KyBrQiIuCi1ISU5UOiAgVmFsaWQgdW5pdHMgYXJlICJieXRlcyIsICJrQiIsICJNQiIsICJH QiIsICJUQiIsIGFuZCAiUEIiLgorSElOVDogIFZhbGlkIHVuaXRzIGFyZSAiYnl0ZXMiLCAi QiIsICJrQiIsICJNQiIsICJHQiIsICJUQiIsIGFuZCAiUEIiLgogU0VMRUNUIHBnX3NpemVf Ynl0ZXMoJysrMTIzIGtCJyk7CiBFUlJPUjogIGludmFsaWQgc2l6ZTogIisrMTIzIGtCIgpk aWZmIC0tZ2l0IGEvc3JjL3Rlc3QvcmVncmVzcy9zcWwvZGJzaXplLnNxbCBiL3NyYy90ZXN0 L3JlZ3Jlc3Mvc3FsL2Ric2l6ZS5zcWwKaW5kZXggN2RmODY1MjcxYi4uYjM0Y2YzMzM4NSAx MDA2NDQKLS0tIGEvc3JjL3Rlc3QvcmVncmVzcy9zcWwvZGJzaXplLnNxbAorKysgYi9zcmMv dGVzdC9yZWdyZXNzL3NxbC9kYnNpemUuc3FsCkBAIC0yOSw3ICsyOSw3IEBACiAKIC0tIHBn X3NpemVfYnl0ZXMoKSB0ZXN0cwogU0VMRUNUIHNpemUsIHBnX3NpemVfYnl0ZXMoc2l6ZSkg RlJPTQotICAgIChWQUxVRVMgKCcxJyksICgnMTIzYnl0ZXMnKSwgKCcxa0InKSwgKCcxTUIn KSwgKCcgMSBHQicpLCAoJzEuNSBHQiAnKSwKKyAgICAoVkFMVUVTICgnMScpLCAoJzEyM2J5 dGVzJyksICgnMjU2IEInKSwgKCcxa0InKSwgKCcxTUInKSwgKCcgMSBHQicpLCAoJzEuNSBH QiAnKSwKICAgICAgICAgICAgICgnMVRCJyksICgnMzAwMCBUQicpLCAoJzFlNiBNQicpLCAo Jzk5IFBCJykpIHgoc2l6ZSk7CiAKIC0tIGNhc2UtaW5zZW5zaXRpdmUgdW5pdHMgYXJlIHN1 cHBvcnRlZAotLSAKMi4zOS4yCgo= --------------qIqcRUaJV5rz1GoLPVnJ3Gwf--