On Fri, Jul 29, 2005 at 03:33:09PM -0400, Tom Lane wrote: > 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.
Oops :-( Didn't notice that. > Also the patch seemed to be missing diffs for header files? Damn, I generated the diff from within src/backend instead of the root :-( Sorry for the inconvenience. > 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. Hmm. Will see about it. -- Alvaro Herrera (<alvherre[a]alvh.no-ip.org>) "La Primavera ha venido. Nadie sabe como ha sido" (A. Machado) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
