Type: | bool |
Default: | on |
Context: | user |
Restart: | false |
Enables or disables the query planner's use of sequential scan plan types. It is impossible to suppress sequential scans entirely, but turning this variable off discourages the planner from using one if there are other methods available. The default is on
.
Recommendations
For interactive session use only when troubleshooting queries.
On StackOverflow
On pgsql-hackers
- Re: Avoiding superfluous buffer locking during nbtree backwards scans
- EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on
- Re: EXPLAIN IndexOnlyScan shows disabled when enable_indexonlyscan=on
- Wrong results with equality search using trigram index and non-deterministic collation
- Re: Why don't we consider explicit Incremental Sort?