Re: Autovacuum Improvements

Glen Parker wrote:
> Alvaro Herrera wrote:
> >>>4) Expose all information used by autovacuum to form its decisions.
> >>You could argue that this is already there, although not easy to get at
> >>I suppose. But all table threshold settings are available either in the
> >>pg_autovacuum relation or the defaults via GUC variables, that plus a
> >>little math will get the information autovacuum uses to form its
> >>decisions.
> >
> >No, we currently don't expose the number of dead tuples which autovacuum
> >uses.
>
> I'd prefer to get this working somehow before 8.3. In the mean time, is
> this information available at all? I assume a c function could get it,
> right? Any easier way?

A C function would do. I don't think anything else would because we
don't expose it at the SQL level.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.