Re: temporarily stop autovacuum

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, jd(at)commandprompt(dot)com, Tatsuo Ishii <ishii(at)postgresql(dot)org>
Subject: Re: temporarily stop autovacuum
Date: 2009-02-12 06:15:36
Message-ID: 200902120815.37593.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wednesday 11 February 2009 20:10:46 Tom Lane wrote:
> AFAIR we pointed out from day one that pg_autovacuum was a temporary
> API that we were not promising to keep around.  Anybody who was coding
> against it with the expectation that they'd not have to change that code
> later was willfully ignoring the warning label.

Indeed. I'm just saying, there is now no way to conveniently change the
settings for many tables at once.

This is perhaps the same kind of issue as GRANT SELECT ON ALL TABLES etc. that
people occassionally ask for. Doing DDL on a group of tables at once.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message ITAGAKI Takahiro 2009-02-12 06:55:33 fillfactor for toast tables is useless?
Previous Message Fujii Masao 2009-02-12 05:08:03 Re: Synch Replication