Re: new GUC var: autovacuum_process_all_tables - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: new GUC var: autovacuum_process_all_tables
Date
Msg-id 1233870014.4500.592.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Re: new GUC var: autovacuum_process_all_tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: new GUC var: autovacuum_process_all_tables
List pgsql-hackers
On Thu, 2009-02-05 at 16:29 -0500, Tom Lane wrote:

> It'd make more sense to put the effort into developing
> better scheduling control over autovacuum, such as a concept of
> maintenance windows.

We need that as well, not instead of.

People want to be able to specify (as an example)
* autovac these problem tables anytime required
* for all other tables disable AV, except on sundays [non-busy-times]

If we're going to build in scheduling featured for AV, I'd like to make
those scheduling features available to user defined tasks also. No need
to limit ourselves to just AV.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: new GUC var: autovacuum_process_all_tables
Next
From: Simon Riggs
Date:
Subject: Re: new GUC var: autovacuum_process_all_tables