Index: contrib/pg_autovacuum/README.pg_autovacuum =================================================================== RCS file: /cvsroot/pgsql/contrib/pg_autovacuum/README.pg_autovacuum,v retrieving revision 1.13 diff -c -c -r1.13 README.pg_autovacuum *** contrib/pg_autovacuum/README.pg_autovacuum 30 Mar 2005 05:05:01 -0000 1.13 --- contrib/pg_autovacuum/README.pg_autovacuum 19 Apr 2005 03:30:38 -0000 *************** *** 123,128 **** --- 123,132 ---- -V vacuum scaling factor: see "Vacuum and Analyze" below. -a analyze base threshold: see "Vacuum and Analyze" below. -A analyze scaling factor: see "Vacuum and Analyze" below. + -i update interval: how often (in terms of iterations of the primary loop + over the database list) to update the database list. The default is 2, + which means the list will be updated before every other pass through + the database list. -L log file: Name of file to which output is submitted, otherwise STDERR -U username: Username pg_autovacuum will use to connect with, if not specified the current username is used. *************** *** 157,162 **** --- 161,167 ---- -A 1 (half of -V if not specified) -s 300 (5 minutes) -S 2 + -i 2 The following arguments are used on Windows only: Index: contrib/pg_autovacuum/pg_autovacuum.c =================================================================== RCS file: /cvsroot/pgsql/contrib/pg_autovacuum/pg_autovacuum.c,v retrieving revision 1.30 diff -c -c -r1.30 pg_autovacuum.c *** contrib/pg_autovacuum/pg_autovacuum.c 3 Apr 2005 00:01:51 -0000 1.30 --- contrib/pg_autovacuum/pg_autovacuum.c 19 Apr 2005 03:30:39 -0000 *************** *** 1103,1108 **** --- 1103,1109 ---- args->analyze_base_threshold = -1; args->analyze_scaling_factor = -1; args->debug = AUTOVACUUM_DEBUG; + args->update_interval = UPDATE_INTERVAL; #ifndef WIN32 args->daemonize = 0; #else *************** *** 1157,1162 **** --- 1158,1166 ---- case 'A': args->analyze_scaling_factor = atof(optarg); break; + case 'i': + args->update_interval = atoi(optarg); + break; case 'c': args->av_vacuum_cost_delay = atoi(optarg); break; *************** *** 1341,1346 **** --- 1345,1352 ---- log_entry(logbuffer, LVL_INFO); sprintf(logbuffer, " args->analyze_scaling_factor=%f", args->analyze_scaling_factor); log_entry(logbuffer, LVL_INFO); + sprintf(logbuffer, " args->update_interval=%i", args->update_interval); + log_entry(logbuffer, LVL_INFO); if (args->av_vacuum_cost_delay != -1) sprintf(logbuffer, " args->av_vacuum_cost_delay=%d", args->av_vacuum_cost_delay); *************** *** 1646,1653 **** } } ! if (loops % UPDATE_INTERVAL == 0) /* Update the list if it's ! * time */ update_db_list(db_list); /* Add and remove databases from * the list */ --- 1652,1659 ---- } } ! if (loops % args->update_interval == 0) /* Update the list if it's ! * time */ update_db_list(db_list); /* Add and remove databases from * the list */ *************** *** 1661,1668 **** if (dbs->conn != NULL) { ! if (loops % UPDATE_INTERVAL == 0) /* Update the list if ! * it's time */ update_table_list(dbs); /* Add and remove tables * from the list */ --- 1667,1674 ---- if (dbs->conn != NULL) { ! if (loops % args->update_interval == 0) /* Update the list if ! * it's time */ update_table_list(dbs); /* Add and remove tables * from the list */ Index: contrib/pg_autovacuum/pg_autovacuum.h =================================================================== RCS file: /cvsroot/pgsql/contrib/pg_autovacuum/pg_autovacuum.h,v retrieving revision 1.14 diff -c -c -r1.14 pg_autovacuum.h *** contrib/pg_autovacuum/pg_autovacuum.h 2 Dec 2004 22:48:10 -0000 1.14 --- contrib/pg_autovacuum/pg_autovacuum.h 19 Apr 2005 03:30:39 -0000 *************** *** 44,49 **** --- 44,50 ---- { int vacuum_base_threshold, analyze_base_threshold, + update_interval, sleep_base_value, debug,