{"Entry":{"collection":"guc","key":"ignore_system_indexes","name":"ignore_system_indexes","aliases":[],"metadata":{"baseline":false,"boot_human":"Not specified","boot_val":null,"category":"Developer Options","category_zh":"","changed_in":[],"changes":[{"documentation_changed":false,"fields":{},"from":"8.1","status":"added","to":"8.2"}],"content_hash":"d87fab6126783e7ae4999b24a5db09a0d9b9a2481f33d4709d85a281cc9154f9","context":"","default_changed_in":[],"default_history":[{"from":"9.0","to":"19","value":"off"}],"derived_content_hash":"b81b8b6c7f7e8ecb6b275f56b8c7338f97a07ef76c3cbcfc8836c69522ce1e8a","documentation_refresh":{"batch":"20261113","original_source_rev":"wiki-repair-20261023:7740a111e2a45536592e6dc348fef2fa862511093f4b630ca4d22cd89e5ff29b","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"editorial":{"advice":{"olap":"Read-only analytics does not make ignore_system_indexes safe: corrupted pages can still poison results or structures. Use only on a disposable salvage copy with explicit acceptance of lost data.","oltp":"Never use ignore_system_indexes as tuning or a steady-state availability setting. Stop writes, preserve immutable copies, exhaust backup/storage repair, document expected data loss, salvage narrowly, rebuild, and validate before any return to service.","small":"Do not enable ignore_system_indexes merely because no replica exists. Preserve the original first and seek a clean backup; this switch can convert visible corruption into silent loss."},"mechanism":["ignore_system_indexes makes a newly started backend read system catalogs without using their indexes, while catalog modifications still update the indexes. It is intended to recover from damaged system indexes.","Because its backend context is fixed at session start, changing the setting inside an existing session is ineffective. Catalog scans can become very slow.","The mode does not repair an index; it only creates a path to inspect data and REINDEX the damaged system index. Leaving it enabled hides symptoms and imposes broad catalog overhead. Its backend context fixes the value during connection startup; an existing session cannot change it."],"pitfalls":["Leaving ignore_system_indexes enabled after the bounded diagnostic or recovery task.","Running the experiment on the only copy of production data.","Underestimating log, core-file, temporary-file, WAL, CPU, or connection-slot amplification.","Treating a server that merely starts or completes a query as proof that data and behavior are correct."],"references":[{"title":"PostgreSQL 19 Beta 4: ignore_system_indexes","url":"https://www.postgresql.org/docs/19/runtime-config-developer.html#GUC-IGNORE-SYSTEM-INDEXES"},{"title":"PostgreSQL 19 release notes","url":"https://www.postgresql.org/docs/19/release-19.html"}],"related":["allow_system_table_mods","ignore_checksum_failure","zero_damaged_pages","shared_buffers"],"summary":"ignore_system_indexes — Disables reading from system indexes. Observed in PG9.0–19 Beta 4; its last measured boot default is off in PG19 Beta 4, with backend context. This is a beta-snapshot fact and can change before PostgreSQL 19 GA."},"enumvals":[],"first_version":"8.2","group":"Developer Options","group_slug":"developer","imported_at":"2026-09-27T17:57:31.392833+08:00","intro_commit":{},"key":"ignore_system_indexes","last_version":"20","max_val":"","min_val":"","name":"ignore_system_indexes","position":178,"present_in":["8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"repair_provenance":{"original_source_revision":"wiki-repair-20261023:050fde4d478f83a40fd45e4c9d9b03dbfe539d9e75d29a307996620fd0fb8d31","receipt_sha256":"150d48c515f6519de9e0f07c62bab76ebf44ad1ecf1f5a1619555cce2427e745","repair":"wiki-repair-20261023"},"short_desc":"Ignore system indexes when reading system tables (but still update the indexes when modifying the tables).","short_desc_zh":"","source_rev":"wiki-repair-20261023:7740a111e2a45536592e6dc348fef2fa862511093f4b630ca4d22cd89e5ff29b","unit":"","vartype":"bool"}},"Definition":{"Collection":"guc","Key":"ignore_system_indexes","SourceDatabase":"center","Version":"18","SourceTable":"guc","SourceKey":"ignore_system_indexes","SourceRevision":"wiki-repair-20261023:7740a111e2a45536592e6dc348fef2fa862511093f4b630ca4d22cd89e5ff29b","Facts":{"boot_val":"off","category":"Developer Options","context":"backend","description":"Ignore system indexes when reading system tables (but still update the indexes when modifying the tables). This is useful when recovering from damaged system indexes. This parameter cannot be changed after session start.","description_zh":"读取系统表时忽略系统索引（但是修改系统表时依然同时更新索引）。这在从被破坏的系统索引中恢复数据时有用。这个参数在会话开始之后不能被更改。","description_zh_html":"\u003cp\u003e\n        读取系统表时忽略系统索引（但是修改系统表时依然同时更新索引）。这在从被破坏的系统索引中恢复数据时有用。这个参数在会话开始之后不能被更改。\n       \u003c/p\u003e","doc":{"anchor":"GUC-IGNORE-SYSTEM-INDEXES","file":"runtime-config-developer.html","lang":"en","sha256":"a3f6a107ed6ba4edaf6df03e52f4a469bd09350d545e4ff419e62844025ec1cf","slug":"18"},"doc_html":"\u003cp\u003e\n        Ignore system indexes when reading system tables (but still\n        update the indexes when modifying the tables).  This is useful\n        when recovering from damaged system indexes.\n        This parameter cannot be changed after session start.\n       \u003c/p\u003e","doc_same_as":"","documentation_revision":{"inputs":[{"file":"runtime-config-developer.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"a3f6a107ed6ba4edaf6df03e52f4a469bd09350d545e4ff419e62844025ec1cf","version":"18.7"},{"file":"runtime-config-developer.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"e7e22aa5738a1d376b84af1adca796c5e14746266733f925eb50c3ef86a50655","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"documented":true,"enumvals":null,"extra_desc":"It does not prevent updating the indexes, so it is safe to use.  The worst consequence is slowness.","lang":"en","max_val":null,"metadata_version":"18","min_val":null,"name":"ignore_system_indexes","short_desc":"Disables reading from system indexes.","source":"pg-settings-source-snapshot","translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/runtime-config-developer.html","sha256":"3c08bf624188bbb0733dc7854e61c0c251c2578311ac3dc8fa626ab21b7911d1"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"unit":null,"vartype":"bool","zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"GUC-IGNORE-SYSTEM-INDEXES","file":"runtime-config-developer.html","lang":"en","sha256":"a3f6a107ed6ba4edaf6df03e52f4a469bd09350d545e4ff419e62844025ec1cf","slug":"18"}},"MeasuredEvidence":{"metadata_version":"18"}},"Text":{"Collection":"guc","Key":"ignore_system_indexes","SourceDatabase":"center","Version":"18","Locale":"en","Title":"ignore_system_indexes","Summary":"Ignore system indexes when reading system tables (but still update the indexes when modifying the tables). This is useful when recovering from damaged system indexes. This parameter cannot be changed after session start.","BodyHTML":"\u003cp\u003e\n        Ignore system indexes when reading system tables (but still\n        update the indexes when modifying the tables).  This is useful\n        when recovering from damaged system indexes.\n        This parameter cannot be changed after session start.\n       \u003c/p\u003e","SourceRevision":"wiki-repair-20261023:7740a111e2a45536592e6dc348fef2fa862511093f4b630ca4d22cd89e5ff29b","ContentHash":"e51ec2b027f962d88ab0320ad623b6d210e737b354fb89945a5bdee58508bdd7","Payload":{"description":"Ignore system indexes when reading system tables (but still update the indexes when modifying the tables). This is useful when recovering from damaged system indexes. This parameter cannot be changed after session start."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}