{"Entry":{"collection":"relopts","key":"gist-buffering","name":"buffering","aliases":["gist.buffering"],"metadata":{"aliases":["gist.buffering"],"category":"GiST indexes","content_hash":"4baad6b10cab1099b55d564baad919149b8e76f11edd173a9a71ace344151787","derived_content_hash":"1220f6a3bb9f0e22c4da6d93c33868918330158499d2168e59f3bf6db45823a4","imported_at":"2026-09-30T17:44:22.150284+08:00","name":"buffering","name_zh":"buffering","repair_provenance":{"original_source_revision":"","receipt_sha256":"9ee416e58d065f980397b7d94067a56247487c2ab09a2d9365d1a9c53abc05d9","repair":"wiki-repair-20261023"},"slug":"gist-buffering","source_rev":"wiki-repair-20261023:4fbd27a2cf2b53261ac160a9debe53bb8de5fe5177270a51433d5c94c3955de9","summary":"Controls whether the buffered build technique described in Section 65.2.4.1 is used to build the index. With OFF buffering is disabled, with ON it is enabled, and with AUTO it is initially disabled, but is turned on on-the-fly once the index size reaches effective_cache_size . The default is AUTO . Note that if sorted build is possible, it will be used instead of buffered build unless buffering=ON is specified."}},"Definition":{"Collection":"relopts","Key":"gist-buffering","SourceDatabase":"center","Version":"18","SourceTable":"relopt","SourceKey":"gist-buffering","SourceRevision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744","Facts":{"description":["Controls whether the buffered build technique described in Section 65.2.4.1 is used to build the index. With OFF buffering is disabled, with ON it is enabled, and with AUTO it is initially disabled, but is turned on on-the-fly once the index size reaches effective_cache_size . The default is AUTO . Note that if sorted build is possible, it will be used instead of buffered build unless buffering=ON is specified."],"description_zh":"控制是否使用第 65.2.4.1 节中描述的缓冲构建技术来构建索引。设置为 OFF 时禁用缓冲构建，设置为 ON 时启用，设置为 AUTO 时初始为禁用，但一旦索引大小达到 effective_cache_size，就会在运行过程中启用。默认值为 AUTO。注意，如果可以使用排序构建，则除非指定 buffering=ON，否则会改用排序构建而不是缓冲构建。","description_zh_html":"\u003cp\u003e\n     控制是否使用\u003ca class=\"xref\" href=\"/zh/docs/18/gist.html#GIST-BUFFERING-BUILD\" title=\"65.2.4.1. GiST 索引构建方法\"\u003e第 65.2.4.1 节\u003c/a\u003e中描述的缓冲构建技术来构建索引。设置为 \u003ccode class=\"literal\"\u003eOFF\u003c/code\u003e 时禁用缓冲构建，设置为\n     \u003ccode class=\"literal\"\u003eON\u003c/code\u003e 时启用，设置为 \u003ccode class=\"literal\"\u003eAUTO\u003c/code\u003e 时初始为禁用，但一旦索引大小达到 \u003ca class=\"xref\" href=\"/zh/docs/18/runtime-config-query.html#GUC-EFFECTIVE-CACHE-SIZE\"\u003eeffective_cache_size\u003c/a\u003e，就会在运行过程中启用。默认值为 \u003ccode class=\"literal\"\u003eAUTO\u003c/code\u003e。注意，如果可以使用排序构建，则除非指定 \u003ccode class=\"literal\"\u003ebuffering=ON\u003c/code\u003e，否则会改用排序构建而不是缓冲构建。\n    \u003c/p\u003e","facts":[{"label":"Applies to","value":"GiST indexes"},{"label":"Value type","value":"enum"},{"label":"Default","value":"AUTO"}],"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 GiST 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 (buffering = value)","sources":[{"label":"PostgreSQL 18 English manual","path":"sql-createindex.html","sha256":"6aa00da55815d13d0355dd25cb1cdb603fa36964993f164d1b6f486011282580","url":"/docs/18/sql-createindex.html#INDEX-RELOPTION-BUFFERING"}],"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-BUFFERING"}]},"MeasuredEvidence":{}},"Text":{"Collection":"relopts","Key":"gist-buffering","SourceDatabase":"center","Version":"18","Locale":"en","Title":"buffering","Summary":"Controls whether the buffered build technique described in Section 65.2.4.1 is used to build the index. With OFF buffering is disabled, with ON it is enabled, and with AUTO it is initially disabled, but is turned on on-the-fly once the index size reaches effective_cache_size . The default is AUTO . Note that if sorted build is possible, it will be used instead of buffered build unless buffering=ON is specified.","BodyHTML":"\u003cp\u003eControls whether the buffered build technique described in Section 65.2.4.1 is used to build the index. With OFF buffering is disabled, with ON it is enabled, and with AUTO it is initially disabled, but is turned on on-the-fly once the index size reaches effective_cache_size . The default is AUTO . Note that if sorted build is possible, it will be used instead of buffered build unless buffering=ON is specified.\u003c/p\u003e","SourceRevision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744","ContentHash":"00f17078b859b9710686841eee9d748fcb2c17554aaea3968895ca15787d29e5","Payload":{"description":["Controls whether the buffered build technique described in Section 65.2.4.1 is used to build the index. With OFF buffering is disabled, with ON it is enabled, and with AUTO it is initially disabled, but is turned on on-the-fly once the index size reaches effective_cache_size . The default is AUTO . Note that if sorted build is possible, it will be used instead of buffered build unless buffering=ON is specified."],"related":[{"label":"CREATE INDEX","url":"/wiki/sql/create-index/?v=18"}],"sections":[{"paragraphs":["This entry applies to GiST 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}