Manage
CO.NF for your Blog
Configuration Snippet Parameter Snippet

enable_nestloop

  1. Documentation
  2. Query Tuning
  3. Planner Method Configuration
  4. enable_nestloop
COPY SHARING LINK
Type: bool
Default: on
Context: user
Restart: false
Enables the planner's use of nested-loop join plans

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.

Official docs

Search in source code

Recommendations

For interactive session use only when troubleshooting queries.
By annotated.conf

Comments