{"kind": "relopts", "major": "18", "item": {"slug": "gin-gin-pending-list-limit", "name": "gin_pending_list_limit", "name_zh": "gin_pending_list_limit", "category": "GIN indexes", "summary": "Overrides the global setting of gin_pending_list_limit for this index. This value is specified in kilobytes.", "aliases": ["gin.gin_pending_list_limit"], "versions": {"10": {"facts": [{"label": "Applies to", "value": "GIN indexes"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/guc/gin_pending_list_limit/?v=10", "label": "Global parameter gin_pending_list_limit"}, {"url": "/docs/sql/create-index/?v=10", "label": "CREATE INDEX"}], "release": {"ref": "Local English manual 10.23", "label": "10.23", "major": "10", "channel": "historical", "revision": "4ff6f6193d91bf44fc701f657cc3295850bf786e42eafbfeed9f4879c3522613"}, "sources": [{"url": "/docs/10/sql-createindex.html#SQL-CREATEINDEX-STORAGE-PARAMETERS", "path": "sql-createindex.html", "label": "PostgreSQL 10 English manual", "sha256": "7b1817d528a7de6c346b120316ca74abde75ccf0f2f21c34a72dbe032a88e403"}, {"url": "/docs/10/runtime-config-client.html#GUC-GIN-PENDING-LIST-LIMIT", "path": "runtime-config-client.html", "label": "Related global parameter: gin_pending_list_limit", "sha256": "81c199a46b03a65a060e25cf874fc7ddd28b18261a6472a912954073556935b4"}], "sections": [{"title": "Index access method", "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": "Related global parameter: gin_pending_list_limit", "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 the GIN 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 main GIN data structure in bulk. The default is four megabytes ( 4MB ). This setting can be overridden for individual GIN indexes by changing index storage parameters. See Section 64.4.1 and Section 64.5 for more information."]}], "signature": "WITH (gin_pending_list_limit = value)", "description": ["Custom gin_pending_list_limit parameter. This value is specified in kilobytes."]}, "11": {"facts": [{"label": "Applies to", "value": "GIN indexes"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/guc/gin_pending_list_limit/?v=11", "label": "Global parameter gin_pending_list_limit"}, {"url": "/docs/sql/create-index/?v=11", "label": "CREATE INDEX"}], "release": {"ref": "Local English manual 11.22", "label": "11.22", "major": "11", "channel": "historical", "revision": "284f2186559443efefbb1ea3b00740c25dccd01e540ecbdb81dadf5127e54a0b"}, "sources": [{"url": "/docs/11/sql-createindex.html#SQL-CREATEINDEX-STORAGE-PARAMETERS", "path": "sql-createindex.html", "label": "PostgreSQL 11 English manual", "sha256": "e7cfb07816fa696f1a7d5a3a8c43287796d08f48bddd6b2413279895b57ff2da"}, {"url": "/docs/11/runtime-config-client.html#GUC-GIN-PENDING-LIST-LIMIT", "path": "runtime-config-client.html", "label": "Related global parameter: gin_pending_list_limit", "sha256": "488947b3f6c09ac9a815b8602e852239936b403ef214249fee7aeca1469c25ba"}], "sections": [{"title": "Index access method", "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": "Related global parameter: gin_pending_list_limit", "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 the GIN 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 main GIN data structure in bulk. The default is four megabytes ( 4MB ). This setting can be overridden for individual GIN indexes by changing index storage parameters. See Section 66.4.1 and Section 66.5 for more information."]}], "signature": "WITH (gin_pending_list_limit = value)", "description": ["Custom gin_pending_list_limit parameter. This value is specified in kilobytes."]}, "12": {"facts": [{"label": "Applies to", "value": "GIN indexes"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/guc/gin_pending_list_limit/?v=12", "label": "Global parameter gin_pending_list_limit"}, {"url": "/docs/sql/create-index/?v=12", "label": "CREATE INDEX"}], "release": {"ref": "Local English manual 12.22", "label": "12.22", "major": "12", "channel": "historical", "revision": "0a1032bc0c23478646e9ee7d36edb066dca27b8540fd64d7fd47dcb6a8a6ccb4"}, "sources": [{"url": "/docs/12/sql-createindex.html#INDEX-RELOPTION-GIN-PENDING-LIST-LIMIT", "path": "sql-createindex.html", "label": "PostgreSQL 12 English manual", "sha256": "deedeb34af9b62564d13ab2d379b31b19d4de6fb89a0e712826211914a0c5805"}, {"url": "/docs/12/runtime-config-client.html#GUC-GIN-PENDING-LIST-LIMIT", "path": "runtime-config-client.html", "label": "Related global parameter: gin_pending_list_limit", "sha256": "7f27882cdde3b36cef070cdd14ce3f080b65ed837d3f6b41f3faf454ba89cc63"}], "sections": [{"title": "Index access method", "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": "Related global parameter: gin_pending_list_limit", "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 66.4.1 and Section 66.5 for more information."]}], "signature": "WITH (gin_pending_list_limit = value)", "description": ["Custom gin_pending_list_limit parameter. This value is specified in kilobytes."]}, "13": {"facts": [{"label": "Applies to", "value": "GIN indexes"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/guc/gin_pending_list_limit/?v=13", "label": "Global parameter gin_pending_list_limit"}, {"url": "/docs/sql/create-index/?v=13", "label": "CREATE INDEX"}], "release": {"ref": "Local English manual 13.23", "label": "13.23", "major": "13", "channel": "historical", "revision": "346825c2d5fbebb2bd997afbb2d49edfd782dce050c0b934e84a883e5446a99f"}, "sources": [{"url": "/docs/13/sql-createindex.html#INDEX-RELOPTION-GIN-PENDING-LIST-LIMIT", "path": "sql-createindex.html", "label": "PostgreSQL 13 English manual", "sha256": "a02f612ec64fc7396ab65a1ce4458cd6971bbd8715e2465ae3c5927d20af3840"}, {"url": "/docs/13/runtime-config-client.html#GUC-GIN-PENDING-LIST-LIMIT", "path": "runtime-config-client.html", "label": "Related global parameter: gin_pending_list_limit", "sha256": "5d70022f2524a39e7c5745698de51d867f687c70394779ad154e05648e923c7d"}], "sections": [{"title": "Index access method", "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": "Related global parameter: gin_pending_list_limit", "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 66.4.1 and Section 66.5 for more information."]}], "signature": "WITH (gin_pending_list_limit = value)", "description": ["Custom gin_pending_list_limit parameter. This value is specified in kilobytes."]}, "14": {"facts": [{"label": "Applies to", "value": "GIN indexes"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/guc/gin_pending_list_limit/?v=14", "label": "Global parameter gin_pending_list_limit"}, {"url": "/docs/sql/create-index/?v=14", "label": "CREATE INDEX"}], "release": {"ref": "Local English manual 14.24", "label": "14.24", "major": "14", "channel": "stable", "revision": "b6e7ed6d017bf1d63aae215156cde763babd657199df9fa10123733290c31260"}, "sources": [{"url": "/docs/14/sql-createindex.html#INDEX-RELOPTION-GIN-PENDING-LIST-LIMIT", "path": "sql-createindex.html", "label": "PostgreSQL 14 English manual", "sha256": "f4d42bd08081490a491dc7bf4fa78b2a49da55ebcd0e7f843862548f7c66d70d"}, {"url": "/docs/14/runtime-config-client.html#GUC-GIN-PENDING-LIST-LIMIT", "path": "runtime-config-client.html", "label": "Related global parameter: gin_pending_list_limit", "sha256": "35d48bb20f151039202a7cafbe7c4ffb109262110d62b2ab75844a3d80c2cebb"}], "sections": [{"title": "Index access method", "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": "Related global parameter: gin_pending_list_limit", "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 67.4.1 and Section 67.5 for more information."]}], "signature": "WITH (gin_pending_list_limit = value)", "description": ["Custom gin_pending_list_limit parameter. This value is specified in kilobytes."]}, "15": {"facts": [{"label": "Applies to", "value": "GIN indexes"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/guc/gin_pending_list_limit/?v=15", "label": "Global parameter gin_pending_list_limit"}, {"url": "/docs/sql/create-index/?v=15", "label": "CREATE INDEX"}], "release": {"ref": "Local English manual 15.19", "label": "15.19", "major": "15", "channel": "stable", "revision": "643ecd492fa284d4d55861f15cbd7c0c7451abce96c8d56485bb2729caba37d5"}, "sources": [{"url": "/docs/15/sql-createindex.html#INDEX-RELOPTION-GIN-PENDING-LIST-LIMIT", "path": "sql-createindex.html", "label": "PostgreSQL 15 English manual", "sha256": "d0c693e7bccb80a261cfefed9f515fd2d24fb49395dfcbd61672d7915fa0666c"}, {"url": "/docs/15/runtime-config-client.html#GUC-GIN-PENDING-LIST-LIMIT", "path": "runtime-config-client.html", "label": "Related global parameter: gin_pending_list_limit", "sha256": "fdcf588ddeeac62758840aa3b8d6ead7e37e1b0c72795e339f67db5b23509462"}], "sections": [{"title": "Index access method", "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": "Related global parameter: gin_pending_list_limit", "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 70.4.1 and Section 70.5 for more information."]}], "signature": "WITH (gin_pending_list_limit = value)", "description": ["Custom gin_pending_list_limit parameter. This value is specified in kilobytes."]}, "16": {"facts": [{"label": "Applies to", "value": "GIN indexes"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/guc/gin_pending_list_limit/?v=16", "label": "Global parameter gin_pending_list_limit"}, {"url": "/docs/sql/create-index/?v=16", "label": "CREATE INDEX"}], "release": {"ref": "Local English manual 16.15", "label": "16.15", "major": "16", "channel": "stable", "revision": "0080d7d37081f27216dc4aa4f6ad85ea24c0c0441e702e6d0b190a339fd76f62"}, "sources": [{"url": "/docs/16/sql-createindex.html#INDEX-RELOPTION-GIN-PENDING-LIST-LIMIT", "path": "sql-createindex.html", "label": "PostgreSQL 16 English manual", "sha256": "ede5053e24573587783eee1735daf6cba76010c2773f10ad066d8cdaf7073c83"}, {"url": "/docs/16/runtime-config-client.html#GUC-GIN-PENDING-LIST-LIMIT", "path": "runtime-config-client.html", "label": "Related global parameter: gin_pending_list_limit", "sha256": "e7e096464bd87b0bfc06652cdbbdd175f7a0e955207580049eae2ee394566b20"}], "sections": [{"title": "Index access method", "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": "Related global parameter: gin_pending_list_limit", "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 70.4.1 and Section 70.5 for more information."]}], "signature": "WITH (gin_pending_list_limit = value)", "description": ["Custom gin_pending_list_limit parameter. This value is specified in kilobytes."]}, "17": {"facts": [{"label": "Applies to", "value": "GIN indexes"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/guc/gin_pending_list_limit/?v=17", "label": "Global parameter gin_pending_list_limit"}, {"url": "/docs/sql/create-index/?v=17", "label": "CREATE INDEX"}], "release": {"ref": "Local English manual 17.11", "label": "17.11", "major": "17", "channel": "stable", "revision": "440f894c3464e7cb4fedc9846b948ca21cd2ffcef1697ff56a28eb641ee7c3d8"}, "sources": [{"url": "/docs/17/sql-createindex.html#INDEX-RELOPTION-GIN-PENDING-LIST-LIMIT", "path": "sql-createindex.html", "label": "PostgreSQL 17 English manual", "sha256": "7fdb46b4a32c524457958417502f4036888552e0577352ee66f107019bbfffd6"}, {"url": "/docs/17/runtime-config-client.html#GUC-GIN-PENDING-LIST-LIMIT", "path": "runtime-config-client.html", "label": "Related global parameter: gin_pending_list_limit", "sha256": "e7ba41a33997d251c23f06ccf17978bf1481db92a2c607026f59af86c25d6f50"}], "sections": [{"title": "Index access method", "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": "Related global parameter: gin_pending_list_limit", "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 64.4.4.1 and Section 64.4.5 for more information."]}], "signature": "WITH (gin_pending_list_limit = value)", "description": ["Custom gin_pending_list_limit parameter. This value is specified in kilobytes."]}, "18": {"facts": [{"label": "Applies to", "value": "GIN indexes"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/guc/gin_pending_list_limit/?v=18", "label": "Global parameter gin_pending_list_limit"}, {"url": "/docs/sql/create-index/?v=18", "label": "CREATE INDEX"}], "release": {"ref": "Local English manual 18.6", "label": "18.6", "major": "18", "channel": "stable", "revision": "eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744"}, "sources": [{"url": "/docs/18/sql-createindex.html#INDEX-RELOPTION-GIN-PENDING-LIST-LIMIT", "path": "sql-createindex.html", "label": "PostgreSQL 18 English manual", "sha256": "6aa00da55815d13d0355dd25cb1cdb603fa36964993f164d1b6f486011282580"}, {"url": "/docs/18/runtime-config-client.html#GUC-GIN-PENDING-LIST-LIMIT", "path": "runtime-config-client.html", "label": "Related global parameter: gin_pending_list_limit", "sha256": "6be6cc70f29eca4695dc43b2b2b94c75b7e0eaaa2c00273d7a98488917a7edb7"}], "sections": [{"title": "Index access method", "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": "Related global parameter: gin_pending_list_limit", "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."]}], "signature": "WITH (gin_pending_list_limit = value)", "description": ["Overrides the global setting of gin_pending_list_limit for this index. This value is specified in kilobytes."]}, "19": {"facts": [{"label": "Applies to", "value": "GIN indexes"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/guc/gin_pending_list_limit/?v=19", "label": "Global parameter gin_pending_list_limit"}, {"url": "/docs/sql/create-index/?v=19", "label": "CREATE INDEX"}], "release": {"ref": "Local English manual 19 beta 4", "label": "19 beta 4", "major": "19", "channel": "preview", "revision": "df6d20830d1a09734a2db6ffc3a6138ce80e669294e56a30f6b5d4a89d81aef1"}, "sources": [{"url": "/docs/19/sql-createindex.html#INDEX-RELOPTION-GIN-PENDING-LIST-LIMIT", "path": "sql-createindex.html", "label": "PostgreSQL 19 English manual", "sha256": "e90c2051c335f6636fb68f3b03f98c3282445c537c99fd7d2e74e4943662e224"}, {"url": "/docs/19/runtime-config-client.html#GUC-GIN-PENDING-LIST-LIMIT", "path": "runtime-config-client.html", "label": "Related global parameter: gin_pending_list_limit", "sha256": "b79c9c91df3fa9d8437437c94fbc2054f3b2f320f731c82bf7f8fdc1f326ccaa"}], "sections": [{"title": "Index access method", "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": "Related global parameter: gin_pending_list_limit", "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."]}], "signature": "WITH (gin_pending_list_limit = value)", "description": ["Overrides the global setting of gin_pending_list_limit for this index. This value is specified in kilobytes."]}, "20": {"facts": [{"label": "Applies to", "value": "GIN indexes"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/guc/gin_pending_list_limit/?v=20", "label": "Global parameter gin_pending_list_limit"}, {"url": "/docs/sql/create-index/?v=20", "label": "CREATE INDEX"}], "release": {"ref": "2c10c2ce4d7bcd57543a49ab402af02a39724e0a", "label": "20 devel", "major": "20", "channel": "devel", "revision": "ca199fbaaf6c4bd29cd5a98beaf34d9f4141c15d2f94d1d0202f3204ef18d09f"}, "sources": [{"url": "/docs/devel/sql-createindex.html#INDEX-RELOPTION-GIN-PENDING-LIST-LIMIT", "path": "sql-createindex.html", "label": "PostgreSQL 20 English manual", "sha256": "33a4425c008678a8009be08f283f4f536180f45ebf9f6c2183f06daa3cf385d8"}, {"url": "/docs/devel/runtime-config-client.html#GUC-GIN-PENDING-LIST-LIMIT", "path": "runtime-config-client.html", "label": "Related global parameter: gin_pending_list_limit", "sha256": "bd85c6b5d862762e0a876bed529cf5aca7cfd6c45dd8476b5bd44889fde1c6a4"}], "sections": [{"title": "Index access method", "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": "Related global parameter: gin_pending_list_limit", "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."]}], "signature": "WITH (gin_pending_list_limit = value)", "description": ["Overrides the global setting of gin_pending_list_limit for this index. This value is specified in kilobytes."]}}, "content_hash": "55dab5cd63c99514f82d4a91c0ed7386003d3eb53a7e9000728decc0703dd314", "imported_at": "2026-09-27T09:57:58.914"}, "snapshot": {"facts": [{"label": "Applies to", "value": "GIN indexes"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/guc/gin_pending_list_limit/?v=18", "label": "Global parameter gin_pending_list_limit"}, {"url": "/docs/sql/create-index/?v=18", "label": "CREATE INDEX"}], "release": {"ref": "Local English manual 18.6", "label": "18.6", "major": "18", "channel": "stable", "revision": "eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744"}, "sources": [{"url": "/docs/18/sql-createindex.html#INDEX-RELOPTION-GIN-PENDING-LIST-LIMIT", "path": "sql-createindex.html", "label": "PostgreSQL 18 English manual", "sha256": "6aa00da55815d13d0355dd25cb1cdb603fa36964993f164d1b6f486011282580"}, {"url": "/docs/18/runtime-config-client.html#GUC-GIN-PENDING-LIST-LIMIT", "path": "runtime-config-client.html", "label": "Related global parameter: gin_pending_list_limit", "sha256": "6be6cc70f29eca4695dc43b2b2b94c75b7e0eaaa2c00273d7a98488917a7edb7"}], "sections": [{"title": "Index access method", "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": "Related global parameter: gin_pending_list_limit", "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."]}], "signature": "WITH (gin_pending_list_limit = value)", "description": ["Overrides the global setting of gin_pending_list_limit for this index. This value is specified in kilobytes."]}, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}