| 类型: | bool |
| 默认: | on |
| 上下文: | user |
| 重新开始: | false |
允许或禁止查询规划器使用嵌套循环连接计划。它不可能完全禁止嵌套循环连接，但是关闭这个变量将使得规划器尽可能优先使用其他方法。默认值是on。
建议 [EN]
For interactive session use only when troubleshooting queries.
在 StackOverflow
- rails-5 activerecord postgresql-9.6 enable_nestloop for a single sql query
- Postgresql - Query running a lot faster with enable_nestloop=false. Why is the planner not doing the right thing?
- What are the pitfalls of setting enable_nestloop to OFF
- PostgreSQL 9.2 set enable_nestloop has no effect
- query taking nested loop instead of hash join