| 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: [PATCH] kNN for btree
- Re: BitmapHeapScan streaming read user and prelim refactoring
- Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan
- Re: Why is FOR ORDER BY function getting called when the index is handling ordering?
- Re: Parallel Bitmap Heap Scan reports per-worker stats in EXPLAIN ANALYZE