| Type: | bool |
| Default: | on |
| Context: | user |
| Restart: | false |
Enables or disables the query planner's use of nested-loop join plans. It is impossible to suppress nested-loop joins 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
- rails-5 activerecord postgresql-9.6 enable_nestloop for a single sql query
- Postgresql - Query running a lot faster with enable_nestloop=false. Why is the planner not doing the right thing?
- What are the pitfalls of setting enable_nestloop to OFF
- PostgreSQL 9.2 set enable_nestloop has no effect
- query taking nested loop instead of hash join