Alvaro Herrera <[EMAIL PROTECTED]> writes: > Updated this patch: > - The stat collector is modified so as to keep shared relations separate > from regular ones. Autovacuum understands this. > [etc]
Applied with some fixes --- you had broken the reporting of statistics for shared tables, for one thing. Also the patch seemed to be missing diffs for header files? It occurs to me that vacuuming to prevent XID wraparound is not the only reason to do DB-wide vacuums: we also need to keep pg_database.datvacuumxid from getting too old, else we will have problems with clog bloat. We may need to rethink the test used. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend