Re: Autovacuum Improvements

Glen Parker <glenebob@nwlink.com>

From: Glen Parker <glenebob@nwlink.com>
To: Postgres general mailing list <pgsql-general@postgresql.org>
Date: 2006-12-19T22:11:41Z
Lists: pgsql-hackers
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?

-Glen