PostgreSQL Documentation: enable

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

On StackOverflow

What exactly means the collation 'de-DE-u-kn-true'
De-Identifying PHI For HIPAA
Lazily (de-)serialize JSON with EF Core
Connect to a heroku database with pgadmin
Get breakdown from de-normalized SQL table

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

enable_nestloop

Recommendations

On StackOverflow

On pgsql-hackers

Comments