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.