{"Entry":{"collection":"relopts","key":"gin-gin-pending-list-limit","name":"gin_pending_list_limit","aliases":["gin.gin_pending_list_limit"],"metadata":{"aliases":["gin.gin_pending_list_limit"],"category":"GIN indexes","content_hash":"374558e2c2919627365b241908e723595b1841be56041423e1e222d5615f66b8","derived_content_hash":"063766da5075026528786d6520a567faa83cf8f97c1f6f28eeb615a4c429dd6b","imported_at":"2026-09-30T17:44:22.146632+08:00","name":"gin_pending_list_limit","name_zh":"gin_pending_list_limit","repair_provenance":{"original_source_revision":"","receipt_sha256":"ddf11fcc94bfa014a8aa36d7703258488067e8743fe57e323880b62ed1ccc86b","repair":"wiki-repair-20261023"},"slug":"gin-gin-pending-list-limit","source_rev":"wiki-repair-20261023:d06e2527e9f5cc598df011e60d7643d01ec33c6679b245f742a08f37b97c60b3","summary":"Overrides the global setting of gin_pending_list_limit for this index. This value is specified in kilobytes."}},"Definition":{"Collection":"relopts","Key":"gin-gin-pending-list-limit","SourceDatabase":"center","Version":"18","SourceTable":"relopt","SourceKey":"gin-gin-pending-list-limit","SourceRevision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744","Facts":{"description":["Overrides the global setting of gin_pending_list_limit for this index. This value is specified in kilobytes."],"description_zh":"为该索引覆盖 gin_pending_list_limit 的全局设置。该值以千字节为单位。","description_zh_html":"\u003cp\u003e\n     为该索引覆盖 \u003ca class=\"xref\" href=\"/zh/docs/18/runtime-config-client.html#GUC-GIN-PENDING-LIST-LIMIT\"\u003egin_pending_list_limit\u003c/a\u003e 的全局设置。该值以千字节为单位。\n    \u003c/p\u003e\u003ch3\u003e相关全局参数\u003c/h3\u003e\u003cp\u003e\n        设置 \u003ccode class=\"literal\"\u003efastupdate\u003c/code\u003e 被启用时可以使用的 GIN 索引的待处理列表的最大尺寸。如果该列表增长到超过这个最大尺寸，会通过批量将其中的项移入索引的主 GIN 数据结构来清理列表。如果指定值时没有单位，则以千字节为单位。默认值是四兆字节（\u003ccode class=\"literal\"\u003e4MB\u003c/code\u003e）。可以通过更改索引的存储参数来为个别 GIN 索引覆盖这个设置。更多信息请见\u003ca class=\"xref\" href=\"/zh/docs/18/gin.html#GIN-FAST-UPDATE\" title=\"65.4.4.1. GIN 快速更新技术\"\u003e第 65.4.4.1 节\u003c/a\u003e和\u003ca class=\"xref\" href=\"/zh/docs/18/gin.html#GIN-TIPS\" title=\"65.4.5. GIN 提示和技巧\"\u003e第 65.4.5 节\u003c/a\u003e。\n       \u003c/p\u003e","facts":[{"label":"Applies to","value":"GIN indexes"},{"label":"Value type","value":"integer"}],"related":[{"label":"Global parameter gin_pending_list_limit","url":"/wiki/guc/gin_pending_list_limit/?v=18"},{"label":"CREATE INDEX","url":"/wiki/sql/create-index/?v=18"}],"release":{"channel":"stable","label":"18.6","major":"18","ref":"Local English manual 18.6","revision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744"},"sections":[{"paragraphs":["This entry applies to GIN indexes. Set it with CREATE INDEX WITH or ALTER INDEX SET. Read defaults and behavior for this specific access method."],"title":"Index access method"},{"paragraphs":["The following same-version GUC definition explains its purpose and units. Global defaults and activation rules describe the GUC; the relation-option override rules remain those above.","Sets the maximum size of a GIN index's pending list, which is used when fastupdate is enabled. If the list grows larger than this maximum size, it is cleaned up by moving the entries in it to the index's main GIN data structure in bulk. If this value is specified without units, it is taken as kilobytes. The default is four megabytes ( 4MB ). This setting can be overridden for individual GIN indexes by changing index storage parameters. See Section 65.4.4.1 and Section 65.4.5 for more information."],"title":"Related global parameter: gin_pending_list_limit"}],"signature":"WITH (gin_pending_list_limit = value)","sources":[{"label":"PostgreSQL 18 English manual","path":"sql-createindex.html","sha256":"6aa00da55815d13d0355dd25cb1cdb603fa36964993f164d1b6f486011282580","url":"/docs/18/sql-createindex.html#INDEX-RELOPTION-GIN-PENDING-LIST-LIMIT"},{"label":"Related global parameter: gin_pending_list_limit","path":"runtime-config-client.html","sha256":"6be6cc70f29eca4695dc43b2b2b94c75b7e0eaaa2c00273d7a98488917a7edb7","url":"/docs/18/runtime-config-client.html#GUC-GIN-PENDING-LIST-LIMIT"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/sql-createindex.html","sha256":"ce2d5ba3eb6a7da215b754fefccac3a37794c6ec20de7eac0bf4f97034328d82"},{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/runtime-config-client.html","sha256":"1882f8fd5576909c4fcc44af53077378871e05f5be67723f20fe300273024767"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-pgdoc"},"ManualEvidence":{"release":{"channel":"stable","label":"18.6","major":"18","ref":"Local English manual 18.6","revision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744"},"sources":[{"label":"PostgreSQL 18 English manual","path":"sql-createindex.html","sha256":"6aa00da55815d13d0355dd25cb1cdb603fa36964993f164d1b6f486011282580","url":"/docs/18/sql-createindex.html#INDEX-RELOPTION-GIN-PENDING-LIST-LIMIT"},{"label":"Related global parameter: gin_pending_list_limit","path":"runtime-config-client.html","sha256":"6be6cc70f29eca4695dc43b2b2b94c75b7e0eaaa2c00273d7a98488917a7edb7","url":"/docs/18/runtime-config-client.html#GUC-GIN-PENDING-LIST-LIMIT"}]},"MeasuredEvidence":{}},"Text":{"Collection":"relopts","Key":"gin-gin-pending-list-limit","SourceDatabase":"center","Version":"18","Locale":"en","Title":"gin_pending_list_limit","Summary":"Overrides the global setting of gin_pending_list_limit for this index. This value is specified in kilobytes.","BodyHTML":"\u003cp\u003eOverrides the global setting of gin_pending_list_limit for this index. This value is specified in kilobytes.\u003c/p\u003e","SourceRevision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744","ContentHash":"e8e7e3760a51c1df81db06d0193f05f3186d7a310ffc7785f3dff25a849b3fc8","Payload":{"description":["Overrides the global setting of gin_pending_list_limit for this index. This value is specified in kilobytes."],"related":[{"label":"Global parameter gin_pending_list_limit","url":"/wiki/guc/gin_pending_list_limit/?v=18"},{"label":"CREATE INDEX","url":"/wiki/sql/create-index/?v=18"}],"sections":[{"paragraphs":["This entry applies to GIN indexes. Set it with CREATE INDEX WITH or ALTER INDEX SET. Read defaults and behavior for this specific access method."],"title":"Index access method"},{"paragraphs":["The following same-version GUC definition explains its purpose and units. Global defaults and activation rules describe the GUC; the relation-option override rules remain those above.","Sets the maximum size of a GIN index's pending list, which is used when fastupdate is enabled. If the list grows larger than this maximum size, it is cleaned up by moving the entries in it to the index's main GIN data structure in bulk. If this value is specified without units, it is taken as kilobytes. The default is four megabytes ( 4MB ). This setting can be overridden for individual GIN indexes by changing index storage parameters. See Section 65.4.4.1 and Section 65.4.5 for more information."],"title":"Related global parameter: gin_pending_list_limit"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}