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
On pgsql-hackers
- Re: Why enable_hashjoin Completely disables HashJoin
- Re: Improve the performance of nested loop join in the case of partitioned inner table
- Why enable_hashjoin Completely disables HashJoin
- postgres_fdw: wrong results with self join + enable_nestloop off
- Re: postgres_fdw: wrong results with self join + enable_nestloop off