{"Entry":{"collection":"relopts","key":"gin-fastupdate","name":"fastupdate","aliases":["gin.fastupdate"],"metadata":{"aliases":["gin.fastupdate"],"category":"GIN indexes","content_hash":"1c4bf0a86d3b10392d2bb1686b22a028451d4f0095b10a18c372d54cb9cda795","derived_content_hash":"84b668f0d4fadecd759ae2678a1403a5f3e44a92deadcdf2bf0a5483d4f0f9c7","imported_at":"2026-09-30T17:44:22.143148+08:00","name":"fastupdate","name_zh":"fastupdate","repair_provenance":{"original_source_revision":"","receipt_sha256":"a00631d2a7877bc83d51e9f856bc7e2e1b243c9a92baff6cb72263f4c6c14591","repair":"wiki-repair-20261023"},"slug":"gin-fastupdate","source_rev":"wiki-repair-20261023:bde7e3a0b7667ab8a71f2f7719fc5a7dbcd1109a99278b781189780abf97faa9","summary":"Controls usage of the fast update technique described in Section 65.4.4.1 . ON enables fast update, OFF disables it. The default is ON ."}},"Definition":{"Collection":"relopts","Key":"gin-fastupdate","SourceDatabase":"center","Version":"18","SourceTable":"relopt","SourceKey":"gin-fastupdate","SourceRevision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744","Facts":{"description":["Controls usage of the fast update technique described in Section 65.4.4.1 . ON enables fast update, OFF disables it. The default is ON .","Turning fastupdate off via ALTER INDEX prevents future insertions from going into the list of pending index entries, but does not in itself flush existing entries. You might want to VACUUM the table or call the gin_clean_pending_list function afterward to ensure the pending list is emptied."],"description_zh":"控制第 65.4.4.1 节中描述的快速更新技术的使用。ON 启用快速更新，OFF 禁用快速更新。默认值为 ON。 注意 通过 ALTER INDEX 关闭 fastupdate 会阻止后续插入进入待处理索引项列表，但这本身不会将现有条目移出待处理列表。之后可能需要对该表执行 VACUUM，或调用 gin_clean_pending_list 函数，以确保待处理列表被清空。","description_zh_html":"\u003cp\u003e\n     控制\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中描述的快速更新技术的使用。\u003ccode class=\"literal\"\u003eON\u003c/code\u003e 启用快速更新，\u003ccode class=\"literal\"\u003eOFF\u003c/code\u003e 禁用快速更新。默认值为 \u003ccode class=\"literal\"\u003eON\u003c/code\u003e。\n    \u003c/p\u003e\u003cdiv class=\"note\"\u003e\u003ch3 class=\"title\"\u003e注意\u003c/h3\u003e\u003cp\u003e\n      通过 \u003ccode class=\"command\"\u003eALTER INDEX\u003c/code\u003e 关闭 \u003ccode class=\"literal\"\u003efastupdate\u003c/code\u003e\n      会阻止后续插入进入待处理索引项列表，但这本身不会将现有条目移出待处理列表。之后可能需要对该表执行 \u003ccode class=\"command\"\u003eVACUUM\u003c/code\u003e，或调用\n      \u003ccode class=\"function\"\u003egin_clean_pending_list\u003c/code\u003e 函数，以确保待处理列表被清空。\n     \u003c/p\u003e\u003c/div\u003e","facts":[{"label":"Applies to","value":"GIN indexes"},{"label":"Value type","value":"boolean"},{"label":"Default","value":"ON"}],"related":[{"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"}],"signature":"WITH (fastupdate = value)","sources":[{"label":"PostgreSQL 18 English manual","path":"sql-createindex.html","sha256":"6aa00da55815d13d0355dd25cb1cdb603fa36964993f164d1b6f486011282580","url":"/docs/18/sql-createindex.html#INDEX-RELOPTION-FASTUPDATE"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/sql-createindex.html","sha256":"ce2d5ba3eb6a7da215b754fefccac3a37794c6ec20de7eac0bf4f97034328d82"}],"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-FASTUPDATE"}]},"MeasuredEvidence":{}},"Text":{"Collection":"relopts","Key":"gin-fastupdate","SourceDatabase":"center","Version":"18","Locale":"en","Title":"fastupdate","Summary":"Controls usage of the fast update technique described in Section 65.4.4.1 . ON enables fast update, OFF disables it. The default is ON .\nTurning fastupdate off via ALTER INDEX prevents future insertions from going into the list of pending index entries, but does not in itself flush existing entries. You might want to VACUUM the table or call the gin_clean_pending_list function afterward to ensure the pending list is emptied.","BodyHTML":"\u003cp\u003eControls usage of the fast update technique described in Section 65.4.4.1 . ON enables fast update, OFF disables it. The default is ON .\nTurning fastupdate off via ALTER INDEX prevents future insertions from going into the list of pending index entries, but does not in itself flush existing entries. You might want to VACUUM the table or call the gin_clean_pending_list function afterward to ensure the pending list is emptied.\u003c/p\u003e","SourceRevision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744","ContentHash":"b213c40b4f576399f3d016a31e7960612fca797272d458379726e875c9135315","Payload":{"description":["Controls usage of the fast update technique described in Section 65.4.4.1 . ON enables fast update, OFF disables it. The default is ON .","Turning fastupdate off via ALTER INDEX prevents future insertions from going into the list of pending index entries, but does not in itself flush existing entries. You might want to VACUUM the table or call the gin_clean_pending_list function afterward to ensure the pending list is emptied."],"related":[{"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"}]}},"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}