类型: | bool |
默认: | on |
上下文: | user |
重新开始: | false |
允许或禁止查询规划器使用嵌套循环连接计划。它不可能完全禁止嵌套循环连接,但是关闭这个变量将使得规划器尽可能优先使用其他方法。默认值是on
。
建议 [EN]
For interactive session use only when troubleshooting queries.
在 StackOverflow
在 pgsql-hackers
- Re: disfavoring unparameterized nested loops
- disfavoring unparameterized nested loops
- Re: PATCH: generate fractional cheapest paths in generate_orderedappend_path
- Re: Using each rel as both outer and inner for JOIN_ANTI
- Re: Condition pushdown: why (=) is pushed down into join, but BETWEEN or >= is not?