> OK, well as we wait on the fix for the stats system, let me submit my
Bruce Momjian <bruce@momjian.us>
> OK, well as we wait on the fix for the stats system, let me submit my > patch for pg_autovacuum. This patch assumes that the stats system will > be fixed so that all inserts, updates and deletes performed on shared > tables reguardless of what database those commands were executed from, > will show up in the stats shown in each database. I had to make a further change to this to take quotes off the 'last ANALYZE' in order for it to not overquote the relation name, so there's a _little_ work left to get it to play well. I have deployed it onto several boxes that should be doing some vacuuming over the weekend, and it is now certainly hitting pg_ tables. I would like to present a CVS-oriented patch; unfortunately, I had to change the indentation patterns when editing some of it :-(. The following _may_ be good; not sure... Matthew T. O'Connor Christopher Browne
Files
| Path | Change | +/− |
|---|---|---|
| contrib/pg_autovacuum/pg_autovacuum.c | modified | +20 −19 |
| contrib/pg_autovacuum/pg_autovacuum.h | modified | +3 −3 |
| contrib/pg_autovacuum/README.pg_autovacuum | modified | +97 −62 |