类型: | integer |
默认: | 1024 (8MB) |
最低限度: | 0 (0kB) |
最大: | 715827882 (5726623056kB) |
单元: | 8kB |
上下文: | user |
重新开始: | false |
以来: | 10 |
设置必须扫描的最小表格数据量,以便考虑并行扫描。对于并行顺序扫描, 扫描的表格数据量始终等于表格的大小,但使用索引时, 扫描的表格数据量通常会少一些。默认值是8兆字节(8MB
)。
建议 [EN]
… , unless doing IoT or a read-only database. Raise to 100MB or so if your traffic on the database is very bursty, to prevent the WAL from shrinking too much.
在 StackOverflow
在 pgsql-hackers
- Re: Support run-time partition pruning for hash join
- Re: Parallelize correlated subqueries that execute within each worker
- [PATCH] plpython function causes server panic
- Re: Allow parallel plan for referential integrity checks?
- Re: Parallel Bitmap Heap Scan reports per-worker stats in EXPLAIN ANALYZE