Skip site navigation (1) Skip section navigation (2)

pg_autovacuum UPDATE_INTERVAL cmd arg

From: Thomas F(dot)O'Connell <tfo(at)sitening(dot)com>
To: PgSQL - Patches <pgsql-patches(at)postgresql(dot)org>
Subject: pg_autovacuum UPDATE_INTERVAL cmd arg
Date: 2005-03-08 00:41:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-patches
The following patch should allow UPDATE_INTERVAL to be specified on the 
command line. We find this useful because we frequently deal with 
thousands of tables in an environment where neither the databases nor 
the tables are updated frequently. This helps allow us to cut down on 
the overhead of updating the list for every other primary loop of 

I chose -i as the command-line argument and documented it briefly in 

The patch was applied to the 7.4.7 version of pg_autovacuum in contrib.


Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320

Attachment: pg_autovacuum.txt
Description: text/plain (4.2 KB)


pgsql-patches by date

Next:From: Mark KirkwoodDate: 2005-03-08 01:36:53
Subject: Re: Display Pg buffer cache (WIP)
Previous:From: Neil ConwayDate: 2005-03-07 23:58:36
Subject: Re: fork() refactoring

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group