On Thu, Feb 5, 2009 at 3:45 PM, Alvaro Herrera <alvhe...@commandprompt.com> wrote: > 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?
Sounds horribly confusing. It's not very difficult to write a script to set this value for every table in the database, if that's what you want to do. Having autovacuum_enabled potentially mean two different things depending on the value of some GUC sounds like a recipe for confusion (and no I don't like it any better if we put the global switch somewhere other than a GUC). ...Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers