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?
- PostgreSQL 9.2 set enable_nestloop has no effect
- What are the pitfalls of setting enable_nestloop to OFF
- SQL query running very slow - postrges