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: explain HashAggregate to report bucket and memory stats
- Tid scan increments value of pg_stat_all_tables.seq_scan. (but not seq_tup_read)
- Re: [PATCH] Incremental sort (was: PoC: Partial sort)
- Re: kill_prior_tuple and index scan costing
- Re: Tid scan increments value of pg_stat_all_tables.seq_scan. (but not seq_tup_read)