ignore_system_indexes

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.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

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

boot val: off
category: Developer Options
context: backend
doc same as: Unknown
documented: true
enumvals: Unknown
extra desc: It does not prevent updating the indexes, so it is safe to use. The worst consequence is slowness.
lang: en
max val: Unknown
metadata version: 18
min val: Unknown
name: ignore_system_indexes
short desc: Disables reading from system indexes.
source: pg-settings-source-snapshot
unit: Unknown
vartype: bool

Definition PG 18

Compare versions

Complete source facts

doc html

<p>
        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.
       </p>

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"}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:7740a111e2a45536592e6dc348fef2fa862511093f4b630ca4d22cd89e5ff29b

Text language: en · wiki-repair-20261023:7740a111e2a45536592e6dc348fef2fa862511093f4b630ca4d22cd89e5ff29b