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,
  				
