new GUC var: autovacuum_process_all_tables - Mailing list pgsql-hackers

From Alvaro Herrera
Subject new GUC var: autovacuum_process_all_tables
Date
Msg-id 20090205204502.GE3064@alvh.no-ip.org
Whole thread Raw
Responses Re: new GUC var: autovacuum_process_all_tables  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: new GUC var: autovacuum_process_all_tables  (Simon Riggs <simon@2ndQuadrant.com>)
Re: new GUC var: autovacuum_process_all_tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: new GUC var: autovacuum_process_all_tables  (Robert Haas <robertmhaas@gmail.com>)
Re: new GUC var: autovacuum_process_all_tables  (Euler Taveira de Oliveira <euler@timbira.com>)
Re: new GUC var: autovacuum_process_all_tables  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Hi,

Right now, when autovacuum is turned on we always assume it's supposed
to process all tables except those that have autovacuum_enabled=false.

Now, sometimes it might make more sense to keep it enabled but have it
only check for certain tables, and leave the majority of them disabled.
For this we'd have a separate GUC parameter, as in $SUBJECT (I'm not
wedded to the name), and have the user set autovacuum_enabled=true via
reloptions to enable it.

Opinions?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Hot standby, recovery infra
Next
From: "Joshua D. Drake"
Date:
Subject: Re: new GUC var: autovacuum_process_all_tables