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.
