vacuum_cost_page_dirty
The estimated cost charged when vacuum modifies a block that was previously clean. It represents the extra I/O required to flush the dirty block out to disk again. The default value is 20.
Comments
Type: | integer |
Default: | 20 |
Min: | 0 |
Max: | 10000 |
Context: | user |
Restart: | false |
On StackOverflow
- Postgresql: database is not accepting commands to avoid wraparound data loss
- is there any adverse effect on DB if I set autovacuum scale factor to zero for certain tables?
- Postgresql 9.3 Autovacuum not keeping up despite aggressive settings
- Postgres connection is slow from PHP
- postgresql - too long select request