diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2019-03-10 15:16:21 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2019-03-10 15:16:21 -0400 |
| commit | cbccac371c79d96c44fcd8c9cbb5ff4dedaaa522 (patch) | |
| tree | 2bd7609c8c97b2195d3a2f25deed7a7099542258 /src | |
| parent | 52985e4fea75f1ec742742f27e246a8775c99e08 (diff) | |
| download | postgresql-cbccac371c79d96c44fcd8c9cbb5ff4dedaaa522.tar.gz postgresql-cbccac371c79d96c44fcd8c9cbb5ff4dedaaa522.zip | |
Reduce the default value of autovacuum_vacuum_cost_delay to 2ms.
This is a better way to implement the desired change of increasing
autovacuum's default resource consumption.
Discussion: https://postgr.es/m/28720.1552101086@sss.pgh.pa.us
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/utils/misc/guc.c | 2 | ||||
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index c82804b1b95..fe6c6f8a05a 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -3312,7 +3312,7 @@ static struct config_real ConfigureNamesReal[] = GUC_UNIT_MS }, &autovacuum_vac_cost_delay, - 20, -1, 100, + 2, -1, 100, NULL, NULL, NULL }, diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 6f97a9ae281..cccb5f145a2 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -589,7 +589,7 @@ #autovacuum_multixact_freeze_max_age = 400000000 # maximum multixact age # before forced vacuum # (change requires restart) -#autovacuum_vacuum_cost_delay = 20ms # default vacuum cost delay for +#autovacuum_vacuum_cost_delay = 2ms # default vacuum cost delay for # autovacuum, in milliseconds; # -1 means use vacuum_cost_delay #autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for |