| Type: | bool |
| Default: | off |
| Context: | backend |
| Restart: | false |
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.
Recommendations
Useful for salvaging data from a corrupted database.
On StackOverflow
- Postgresql doesn't use memory for caching
- Geoserver WFS + PostgreSQL with large table impossibly slow
- Why does "explain analyzing" this query fnish fast (showing a parallel plan), while running the actual query without "explain analyze" doesn't?
- Postgresql sequential scan slow performance on 500 million rows