Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> writes:
> The first is to add a column(s) to pg_class to hold last vaccum/analyze time
> for each table.
I really don't want us to do that. relpages/reltuples are already an
ugly wart. The fundamental problem with this (or indeed any of the
various proposals for "let's make vacuum store results someplace")
is that vacuum is supposed to *clean up* dead rows. Not make more.
We don't want a pass of autovacuum to leave pg_class in a desperately-
> The second is to add a "verbosity level" to pg_autovacuum for each table, to
> allow admins to configure specific tables for a more verbose logging.
No fundamental objection, but I can't really see the need either.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2006-04-28 20:18:15|
|Subject: Re: Logging pg_autovacuum |
|Previous:||From: Martijn van Oosterhout||Date: 2006-04-28 20:15:36|
|Subject: Re: Logging pg_autovacuum|