| 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
- Slow query in Postgres while joining tables with 10M rows all join column indexed
- Force PostgreSQL to use hashed join in query
- enabling nested loop join and disabling hash join in postgres.
- Optimize JOIN -> GROUP BY query in PostgreSQL: all indexes are already there
- Cannot find tables that would join using nested loops