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