类型: | bool |
默认: | on |
上下文: | user |
重新开始: | false |
允许或者禁止查询规划器使用物化。它不可能完全禁用物化,但是关闭这个变量将阻止规划器插入物化节点,除非为了保证正确性。默认值是on
。
建议 [EN]
For interactive session use only when troubleshooting queries.
在 StackOverflow
在 pgsql-hackers
- Memory leak in incremental sort re-scan
- Re: Should consider materializing the cheapest inner path in consider_parallel_nestloop()
- Re: Consider parallel for lateral subqueries with limit
- Re: Improve the performance of nested loop join in the case of partitioned inner table
- Re: Memory leak in incremental sort re-scan