From f425b605f4e97a4571372b116a1ec81daf88dfc8 Mon Sep 17 00:00:00 2001 From: Jan Wieck Date: Fri, 6 Feb 2004 19:36:18 +0000 Subject: Cost based vacuum delay feature. Jan --- src/backend/utils/misc/guc.c | 47 +++++++++++++++++++++++++++++++++++++++++++- 1 file changed, 46 insertions(+), 1 deletion(-) (limited to 'src/backend/utils/misc/guc.c') diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index eb79ea2c627..7fe7c33cf8a 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -10,7 +10,7 @@ * Written by Peter Eisentraut . * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.185 2004/02/04 01:24:53 wieck Exp $ + * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.186 2004/02/06 19:36:18 wieck Exp $ * *-------------------------------------------------------------------- */ @@ -1047,6 +1047,51 @@ static struct config_int ConfigureNamesInt[] = 16384, 1024, INT_MAX / 1024, NULL, NULL }, + { + {"vacuum_cost_page_hit", PGC_USERSET, RESOURCES, + gettext_noop("Vacuum cost for a page found in the buffer cache."), + NULL + }, + &VacuumCostPageHit, + 1, 0, 10000, NULL, NULL + }, + + { + {"vacuum_cost_page_miss", PGC_USERSET, RESOURCES, + gettext_noop("Vacuum cost for a page not found in the buffer cache."), + NULL + }, + &VacuumCostPageMiss, + 10, 0, 10000, NULL, NULL + }, + + { + {"vacuum_cost_page_dirty", PGC_USERSET, RESOURCES, + gettext_noop("Vacuum cost for a page dirtied by vacuum."), + NULL + }, + &VacuumCostPageDirty, + 20, 0, 10000, NULL, NULL + }, + + { + {"vacuum_cost_limit", PGC_USERSET, RESOURCES, + gettext_noop("Vacuum cost amount available before napping."), + NULL + }, + &VacuumCostLimit, + 200, 1, 10000, NULL, NULL + }, + + { + {"vacuum_cost_naptime", PGC_USERSET, RESOURCES, + gettext_noop("Vacuum cost naptime in milliseconds."), + NULL + }, + &VacuumCostNaptime, + 0, 0, 1000, NULL, NULL + }, + { {"max_files_per_process", PGC_BACKEND, RESOURCES_KERNEL, gettext_noop("Sets the maximum number of simultaneously open files for each server process."), -- cgit v1.2.3