Type: | bool |
Default: | on |
Context: | user |
Restart: | false |
Enables or disables the query planner's use of hash-join plan types. The default is on
.
Recommendations
For interactive session use only when troubleshooting queries.
On StackOverflow
On pgsql-hackers
- Re: windows CI failing PMSignalState->PMChildFlags[slot] == PM_CHILD_ASSIGNED
- 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
- A potential memory leak on Merge Join when Sort node is not below Materialize node