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.

Comments