| 类型: | integer |
| 默认: | 20 |
| 最低限度: | 0 |
| 最大: | 10000 |
| 上下文: | user |
| 重新开始: | false |
当清理修改一个之前干净的块时需要花费的估计代价。它表示再次把脏块刷出到磁盘所需要的额外I/O。默认值为20。
在 StackOverflow
- vacuum_cost_page_miss set to zero
- Postgresql: database is not accepting commands to avoid wraparound data loss
- PostgreSQL11 space reuse under high delete/update rate
- Postgresql 9.3 Autovacuum not keeping up despite aggressive settings
- is there any adverse effect on DB if I set autovacuum scale factor to zero for certain tables?