Type: | bool |
Default: | on |
Context: | user |
Restart: | false |
Enables or disables the query planner's use of merge-join plan types. The default is on
.
Recommendations
For interactive session use only when troubleshooting queries.
On StackOverflow
On pgsql-hackers
- Re: Improving worst-case merge join performance with often-null foreign key
- Memory leak in incremental sort re-scan
- 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