Revision 12617
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/postgresql.conf | ||
|---|---|---|
| 487 | 487 |
#autovacuum_analyze_scale_factor = 0.1 # fraction of table size before analyze |
| 488 | 488 |
#autovacuum_freeze_max_age = 200000000 # maximum XID age before forced vacuum |
| 489 | 489 |
# (change requires restart) |
| 490 |
# never stall autovacuuming due to a concurrent query, as this can prevent |
|
| 491 |
# autovacuuming from happening altogether |
|
| 492 |
# (http://vegpath.org/links/#PostgreSQL:%20Documentation:%209.3:%20Resource%20Consumption:%2018.4.4.%20Cost-based%20Vacuum%20Delay) |
|
| 493 |
autovacuum_vacuum_cost_delay = -1 # use vacuum_cost_delay (=0) |
|
| 490 | 494 |
#autovacuum_vacuum_cost_delay = 20ms # default vacuum cost delay for |
| 491 | 495 |
# autovacuum, in milliseconds; |
| 492 | 496 |
# -1 means use vacuum_cost_delay |
Also available in: Unified diff
fix: schemas/postgresql.conf: disable autovacuum_vacuum_cost_delay to avoid stalling autovacuuming due to a concurrent query, as this can prevent autovacuuming from happening altogether (http://vegpath.org/links/#PostgreSQL:%20Documentation:%209.3:%20Resource%20Consumption:%2018.4.4.%20Cost-based%20Vacuum%20Delay)