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 1uSCbd-004iYv-8H for pgsql-docs@arkaria.postgresql.org; Thu, 19 Jun 2025 10:34:53 +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 1uSCbb-00APyc-79 for pgsql-docs@arkaria.postgresql.org; Thu, 19 Jun 2025 10:34:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uSCba-00APyU-S4 for pgsql-docs@lists.postgresql.org; Thu, 19 Jun 2025 10:34:51 +0000 Received: from oss.nttdata.com ([49.212.34.109]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1uSCbW-002rRY-31 for pgsql-docs@lists.postgresql.org; Thu, 19 Jun 2025 10:34:49 +0000 Received: from [192.168.11.9] (p1696134-ipoe.ipoe.ocn.ne.jp [118.0.93.133]) by oss.nttdata.com (Postfix) with ESMTPSA id F050D619AC for ; Thu, 19 Jun 2025 19:34:41 +0900 (JST) X-Virus-Status: Clean X-Virus-Scanned: clamav-milter 0.103.11 at oss.nttdata.com Content-Type: multipart/mixed; boundary="------------DnYSy0vZYfjnkfORW80nsvkP" Message-ID: Date: Thu, 19 Jun 2025 19:34:41 +0900 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Content-Language: en-US To: pgsql-docs@lists.postgresql.org From: Fujii Masao Subject: Minor documentation fixes related to v18 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. --------------DnYSy0vZYfjnkfORW80nsvkP Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Hi, I'd like to propose three minor documentation fixes related to parameters introduced in v18. Since they align with new content in that version, I'm thinking to apply them to v18. Thoughts? 0001: For parameters that exist as both configuration and storage options, the documentation usually includes secondary index entries to help users find them easily. However, such entries were missing for vacuum_truncate and vacuum_max_eager_freeze_failure_rate. This patch adds the appropriate index terms. 0002: The description of track_cost_delay_timing lists where cost-based vacuum delay timing information is shown when the setting is enabled. Although this information also appears in ANALYZE VERBOSE output, that wasn't mentioned. This patch adds it to the list. 0003: The io_workers parameter was documented with the type "int", but the standard format in our docs is "integer". This patch updates it for consistency with other GUC parameter descriptions. Regards, -- Fujii Masao NTT DATA Japan Corporation --------------DnYSy0vZYfjnkfORW80nsvkP Content-Type: text/plain; charset=UTF-8; name="v1-0001-doc-Add-secondary-index-entries-for-vacuum-relate.patch" Content-Disposition: attachment; filename*0="v1-0001-doc-Add-secondary-index-entries-for-vacuum-relate.pa"; filename*1="tch" Content-Transfer-Encoding: base64 RnJvbSBlZWUyNmEzYzA1NmU1Yzk5NTFjYzljMzA0YzhhNWI2Y2U0YzQ0ZDljIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBGdWppaSBNYXNhbyA8ZnVqaWlAcG9zdGdyZXNxbC5v cmc+CkRhdGU6IFRodSwgMTkgSnVuIDIwMjUgMTc6NTI6NTggKzA5MDAKU3ViamVjdDogW1BB VENIIHYxIDEvM10gZG9jOiBBZGQgc2Vjb25kYXJ5IGluZGV4IGVudHJpZXMgZm9yIHZhY3V1 bS1yZWxhdGVkCiBwYXJhbWV0ZXJzLgoKRm9yIHBhcmFtZXRlcnMgdGhhdCBleGlzdCBhcyBi b3RoIGNvbmZpZ3VyYXRpb24gYW5kIHN0b3JhZ2Ugb3B0aW9ucywKdGhlIGRvY3VtZW50YXRp b24gdHlwaWNhbGx5IGluY2x1ZGVzIHNlY29uZGFyeSBpbmRleCBlbnRyaWVzIHRvCmhlbHAg dXNlcnMgZGlzdGluZ3Vpc2ggYW5kIGxvY2F0ZSB0aGUgcmVsZXZhbnQgcmVmZXJlbmNlcyBl YXNpbHkuCgpIb3dldmVyLCBzdWNoIGluZGV4IGVudHJpZXMgd2VyZSBtaXNzaW5nIGZvciB2 YWN1dW1fdHJ1bmNhdGUgYW5kCnZhY3V1bV9tYXhfZWFnZXJfZnJlZXplX2ZhaWx1cmVfcmF0 ZSwgYm90aCBpbnRyb2R1Y2VkIGluIHYxOC4KClRoaXMgY29tbWl0IGFkZHMgYXBwcm9wcmlh dGUgc2Vjb25kYXJ5IGluZGV4IHRlcm1zIGZvciB0aGVzZSBwYXJhbWV0ZXJzCnRvIGVuc3Vy ZSBjb25zaXN0ZW5jeSB3aXRoIG90aGVyIHBhcmFtZXRlcnMgYW5kIGltcHJvdmUgdXNhYmls aXR5IG9mCnRoZSBkb2N1bWVudGF0aW9uIGluZGV4LgotLS0KIGRvYy9zcmMvc2dtbC9jb25m aWcuc2dtbCAgICAgICAgICAgfCA2ICsrKystLQogZG9jL3NyYy9zZ21sL3JlZi9jcmVhdGVf dGFibGUuc2dtbCB8IDMgKystCiAyIGZpbGVzIGNoYW5nZWQsIDYgaW5zZXJ0aW9ucygrKSwg MyBkZWxldGlvbnMoLSkKCmRpZmYgLS1naXQgYS9kb2Mvc3JjL3NnbWwvY29uZmlnLnNnbWwg Yi9kb2Mvc3JjL3NnbWwvY29uZmlnLnNnbWwKaW5kZXggYjI2NWNjODljOWQuLjBhYzUxOTcw NmE0IDEwMDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwvY29uZmlnLnNnbWwKKysrIGIvZG9jL3Ny Yy9zZ21sL2NvbmZpZy5zZ21sCkBAIC05MzQwLDcgKzkzNDAsOCBAQCBDT1BZIHBvc3RncmVz X2xvZyBGUk9NICcvZnVsbC9wYXRoL3RvL2xvZ2ZpbGUuY3N2JyBXSVRIIGNzdjsKICAgICAg IDx2YXJsaXN0ZW50cnkgaWQ9Imd1Yy12YWN1dW0tdHJ1bmNhdGUiIHhyZWZsYWJlbD0idmFj dXVtX3RydW5jYXRlIj4KICAgICAgICA8dGVybT48dmFybmFtZT52YWN1dW1fdHJ1bmNhdGU8 L3Zhcm5hbWU+ICg8dHlwZT5ib29sZWFuPC90eXBlPikKICAgICAgICA8aW5kZXh0ZXJtPgot ICAgICAgICA8cHJpbWFyeT48dmFybmFtZT52YWN1dW1fdHJ1bmNhdGU8L3Zhcm5hbWU+IGNv bmZpZ3VyYXRpb24gcGFyYW1ldGVyPC9wcmltYXJ5PgorICAgICAgICA8cHJpbWFyeT48dmFy bmFtZT52YWN1dW1fdHJ1bmNhdGU8L3Zhcm5hbWU+PC9wcmltYXJ5PgorICAgICAgICA8c2Vj b25kYXJ5PmNvbmZpZ3VyYXRpb24gcGFyYW1ldGVyPC9zZWNvbmRhcnk+CiAgICAgICAgPC9p bmRleHRlcm0+CiAgICAgICAgPC90ZXJtPgogICAgICAgIDxsaXN0aXRlbT4KQEAgLTk1NDQs NyArOTU0NSw4IEBAIENPUFkgcG9zdGdyZXNfbG9nIEZST00gJy9mdWxsL3BhdGgvdG8vbG9n ZmlsZS5jc3YnIFdJVEggY3N2OwogICAgICA8dmFybGlzdGVudHJ5IGlkPSJndWMtdmFjdXVt LW1heC1lYWdlci1mcmVlemUtZmFpbHVyZS1yYXRlIiB4cmVmbGFiZWw9InZhY3V1bV9tYXhf ZWFnZXJfZnJlZXplX2ZhaWx1cmVfcmF0ZSI+CiAgICAgICA8dGVybT48dmFybmFtZT52YWN1 dW1fbWF4X2VhZ2VyX2ZyZWV6ZV9mYWlsdXJlX3JhdGU8L3Zhcm5hbWU+ICg8dHlwZT5mbG9h dGluZyBwb2ludDwvdHlwZT4pCiAgICAgICA8aW5kZXh0ZXJtPgotICAgICAgIDxwcmltYXJ5 Pjx2YXJuYW1lPnZhY3V1bV9tYXhfZWFnZXJfZnJlZXplX2ZhaWx1cmVfcmF0ZTwvdmFybmFt ZT4gY29uZmlndXJhdGlvbiBwYXJhbWV0ZXI8L3ByaW1hcnk+CisgICAgICAgPHByaW1hcnk+ PHZhcm5hbWU+dmFjdXVtX21heF9lYWdlcl9mcmVlemVfZmFpbHVyZV9yYXRlPC92YXJuYW1l PjwvcHJpbWFyeT4KKyAgICAgICA8c2Vjb25kYXJ5PmNvbmZpZ3VyYXRpb24gcGFyYW1ldGVy PC9zZWNvbmRhcnk+CiAgICAgICA8L2luZGV4dGVybT4KICAgICAgIDwvdGVybT4KICAgICAg IDxsaXN0aXRlbT4KZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX3RhYmxl LnNnbWwgYi9kb2Mvc3JjL3NnbWwvcmVmL2NyZWF0ZV90YWJsZS5zZ21sCmluZGV4IDRhNDFi MmY1NTMwLi5jYTExMjEzMThjMiAxMDA2NDQKLS0tIGEvZG9jL3NyYy9zZ21sL3JlZi9jcmVh dGVfdGFibGUuc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvcmVmL2NyZWF0ZV90YWJsZS5zZ21s CkBAIC0xNjg3LDcgKzE2ODcsOCBAQCBXSVRIICggTU9EVUxVUyA8cmVwbGFjZWFibGUgY2xh c3M9InBhcmFtZXRlciI+bnVtZXJpY19saXRlcmFsPC9yZXBsYWNlYWJsZT4sIFJFTQogICAg PHZhcmxpc3RlbnRyeSBpZD0icmVsb3B0aW9uLXZhY3V1bS10cnVuY2F0ZSIgeHJlZmxhYmVs PSJ2YWN1dW1fdHJ1bmNhdGUiPgogICAgIDx0ZXJtPjxsaXRlcmFsPnZhY3V1bV90cnVuY2F0 ZTwvbGl0ZXJhbD4sIDxsaXRlcmFsPnRvYXN0LnZhY3V1bV90cnVuY2F0ZTwvbGl0ZXJhbD4g KDx0eXBlPmJvb2xlYW48L3R5cGU+KQogICAgIDxpbmRleHRlcm0+Ci0gICAgIDxwcmltYXJ5 Pjx2YXJuYW1lPnZhY3V1bV90cnVuY2F0ZTwvdmFybmFtZT4gc3RvcmFnZSBwYXJhbWV0ZXI8 L3ByaW1hcnk+CisgICAgIDxwcmltYXJ5Pjx2YXJuYW1lPnZhY3V1bV90cnVuY2F0ZTwvdmFy bmFtZT48L3ByaW1hcnk+CisgICAgIDxzZWNvbmRhcnk+c3RvcmFnZSBwYXJhbWV0ZXI8L3Nl Y29uZGFyeT4KICAgICA8L2luZGV4dGVybT4KICAgICA8L3Rlcm0+CiAgICAgPGxpc3RpdGVt PgotLSAKMi40OS4wCgo= --------------DnYSy0vZYfjnkfORW80nsvkP Content-Type: text/plain; charset=UTF-8; name="v1-0002-doc-Mention-ANALYZE-VERBOSE-in-track_cost_delay_t.patch" Content-Disposition: attachment; filename*0="v1-0002-doc-Mention-ANALYZE-VERBOSE-in-track_cost_delay_t.pa"; filename*1="tch" Content-Transfer-Encoding: base64 RnJvbSAyZTc5M2JhZTU3MWM4MzMzNGUyODg2NTc0ZGJmZjBkYzM0ZTY2YThhIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBGdWppaSBNYXNhbyA8ZnVqaWlAcG9zdGdyZXNxbC5v cmc+CkRhdGU6IFRodSwgMTkgSnVuIDIwMjUgMTg6Mjc6NTIgKzA5MDAKU3ViamVjdDogW1BB VENIIHYxIDIvM10gZG9jOiBNZW50aW9uIEFOQUxZWkUgVkVSQk9TRSBpbgogdHJhY2tfY29z dF9kZWxheV90aW1pbmcgZGVzY3JpcHRpb24uCgpUaGUgZG9jdW1lbnRhdGlvbiBmb3IgdHJh Y2tfY29zdF9kZWxheV90aW1pbmcgZGVzY3JpYmVzIHdoZXJlIGNvc3QtYmFzZWQKdmFjdXVt IGRlbGF5IHRpbWluZyBpbmZvcm1hdGlvbiBpcyBkaXNwbGF5ZWQgd2hlbiB0aGUgc2V0dGlu ZyBpcyBlbmFibGVkLgpXaGlsZSB0aGlzIGluZm9ybWF0aW9uIGlzIGFsc28gc2hvd24gaW4g dGhlIG91dHB1dCBvZiBBTkFMWVpFIFZFUkJPU0UsCnRoYXQgd2FzIHByZXZpb3VzbHkgb21p dHRlZCBmcm9tIHRoZSBsaXN0LgoKVGhpcyBjb21taXQgdXBkYXRlcyB0aGUgZG9jdW1lbnRh dGlvbiB0byBpbmNsdWRlIEFOQUxZWkUgVkVSQk9TRSBpbiB0aGUgbGlzdCwKY2xhcmlmeWlu ZyB0aGF0IGl0IGFsc28gcmVwb3J0cyBjb3N0LWJhc2VkIGRlbGF5IHRpbWluZyBpbmZvcm1h dGlvbi4KLS0tCiBkb2Mvc3JjL3NnbWwvY29uZmlnLnNnbWwgfCAzICsrLQogMSBmaWxlIGNo YW5nZWQsIDIgaW5zZXJ0aW9ucygrKSwgMSBkZWxldGlvbigtKQoKZGlmZiAtLWdpdCBhL2Rv Yy9zcmMvc2dtbC9jb25maWcuc2dtbCBiL2RvYy9zcmMvc2dtbC9jb25maWcuc2dtbAppbmRl eCAwYWM1MTk3MDZhNC4uZjRiYTU4YmI1YzMgMTAwNjQ0Ci0tLSBhL2RvYy9zcmMvc2dtbC9j b25maWcuc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvY29uZmlnLnNnbWwKQEAgLTg2MDIsNyAr ODYwMiw4IEBAIENPUFkgcG9zdGdyZXNfbG9nIEZST00gJy9mdWxsL3BhdGgvdG8vbG9nZmls ZS5jc3YnIFdJVEggY3N2OwogICAgICAgICB0aW1pbmcgaW5mb3JtYXRpb24gaXMgZGlzcGxh eWVkIGluCiAgICAgICAgIDxsaW5rIGxpbmtlbmQ9InZhY3V1bS1wcm9ncmVzcy1yZXBvcnRp bmciPjxzdHJ1Y3RuYW1lPnBnX3N0YXRfcHJvZ3Jlc3NfdmFjdXVtPC9zdHJ1Y3RuYW1lPjwv bGluaz4sCiAgICAgICAgIDxsaW5rIGxpbmtlbmQ9ImFuYWx5emUtcHJvZ3Jlc3MtcmVwb3J0 aW5nIj48c3RydWN0bmFtZT5wZ19zdGF0X3Byb2dyZXNzX2FuYWx5emU8L3N0cnVjdG5hbWU+ PC9saW5rPiwKLSAgICAgICAgaW4gdGhlIG91dHB1dCBvZiA8eHJlZiBsaW5rZW5kPSJzcWwt dmFjdXVtIi8+IHdoZW4gdGhlCisgICAgICAgIGluIHRoZSBvdXRwdXQgb2YgPHhyZWYgbGlu a2VuZD0ic3FsLXZhY3V1bSIvPiBhbmQKKyAgICAgICAgPHhyZWYgbGlua2VuZD0ic3FsLWFu YWx5emUiLz4gd2hlbiB0aGUKICAgICAgICAgPGxpdGVyYWw+VkVSQk9TRTwvbGl0ZXJhbD4g b3B0aW9uIGlzIHVzZWQsIGFuZCBieSBhdXRvdmFjdXVtIGZvcgogICAgICAgICBhdXRvLXZh Y3V1bXMgYW5kIGF1dG8tYW5hbHl6ZXMgd2hlbgogICAgICAgICA8eHJlZiBsaW5rZW5kPSJn dWMtbG9nLWF1dG92YWN1dW0tbWluLWR1cmF0aW9uIi8+IGlzIHNldC4KLS0gCjIuNDkuMAoK --------------DnYSy0vZYfjnkfORW80nsvkP Content-Type: text/plain; charset=UTF-8; name="v1-0003-doc-Fix-type-description-of-io_workers-GUC-for-co.patch" Content-Disposition: attachment; filename*0="v1-0003-doc-Fix-type-description-of-io_workers-GUC-for-co.pa"; filename*1="tch" Content-Transfer-Encoding: base64 RnJvbSAwODI0MzU0NWY0NjZhZDEyMTcwZDRhYmFkZDQ0ZGFkOWQ3MTA1ZDgwIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBGdWppaSBNYXNhbyA8ZnVqaWlAcG9zdGdyZXNxbC5v cmc+CkRhdGU6IFRodSwgMTkgSnVuIDIwMjUgMTk6MDg6MDggKzA5MDAKU3ViamVjdDogW1BB VENIIHYxIDMvM10gZG9jOiBGaXggdHlwZSBkZXNjcmlwdGlvbiBvZiBpb193b3JrZXJzIEdV QyBmb3IKIGNvbnNpc3RlbmN5LgoKVGhlIGRvY3VtZW50YXRpb24gcHJldmlvdXNseSBkZXNj cmliZWQgdGhlIHR5cGUgb2YgdGhlIGlvX3dvcmtlcnMgR1VDCnBhcmFtZXRlciBhcyAiaW50 Ii4gSG93ZXZlciwgdGhlIGRvY3VtZW50YXRpb24gY29uc2lzdGVudGx5IHVzZXMgImludGVn ZXIiCmZvciBwYXJhbWV0ZXJzIG9mIHRoaXMgdHlwZS4KClRoaXMgY29tbWl0IHVwZGF0ZXMg dGhlIHR5cGUgZGVzY3JpcHRpb24gb2YgaW9fd29ya2VycyB0byAiaW50ZWdlciIKZm9yIGNv bnNpc3RlbmN5IHdpdGggb3RoZXIgR1VDIHBhcmFtZXRlciBkZXNjcmlwdGlvbnMuCi0tLQog ZG9jL3NyYy9zZ21sL2NvbmZpZy5zZ21sIHwgMiArLQogMSBmaWxlIGNoYW5nZWQsIDEgaW5z ZXJ0aW9uKCspLCAxIGRlbGV0aW9uKC0pCgpkaWZmIC0tZ2l0IGEvZG9jL3NyYy9zZ21sL2Nv bmZpZy5zZ21sIGIvZG9jL3NyYy9zZ21sL2NvbmZpZy5zZ21sCmluZGV4IGY0YmE1OGJiNWMz Li41OWEwODc0NTI4YSAxMDA2NDQKLS0tIGEvZG9jL3NyYy9zZ21sL2NvbmZpZy5zZ21sCisr KyBiL2RvYy9zcmMvc2dtbC9jb25maWcuc2dtbApAQCAtMjc4OCw3ICsyNzg4LDcgQEAgaW5j bHVkZV9kaXIgJ2NvbmYuZCcKICAgICAgIDwvdmFybGlzdGVudHJ5PgogCiAgICAgICA8dmFy bGlzdGVudHJ5IGlkPSJndWMtaW8td29ya2VycyIgeHJlZmxhYmVsPSJpb193b3JrZXJzIj4K LSAgICAgICA8dGVybT48dmFybmFtZT5pb193b3JrZXJzPC92YXJuYW1lPiAoPHR5cGU+aW50 PC90eXBlPikKKyAgICAgICA8dGVybT48dmFybmFtZT5pb193b3JrZXJzPC92YXJuYW1lPiAo PHR5cGU+aW50ZWdlcjwvdHlwZT4pCiAgICAgICAgPGluZGV4dGVybT4KICAgICAgICAgPHBy aW1hcnk+PHZhcm5hbWU+aW9fd29ya2VyczwvdmFybmFtZT4gY29uZmlndXJhdGlvbiBwYXJh bWV0ZXI8L3ByaW1hcnk+CiAgICAgICAgPC9pbmRleHRlcm0+Ci0tIAoyLjQ5LjAKCg== --------------DnYSy0vZYfjnkfORW80nsvkP--