On Wed, 29 Oct 2003 11:32:12 -0500 Tom Lane <[EMAIL PROTECTED]> wrote:
> Jeff <[EMAIL PROTECTED]> writes: > > [ pg_clog not getting truncated ] > > pg_clog is truncated on the basis of the oldest completely vacuumed > database in your installation. Most likely your maintenance script > is failing to vacuum some database(s) (template1, perhaps?) and/or > is doing table-by-table vacuums rather than an unqualified VACUUM. > > I doubt this explains any performance problems though. Old pg_clog > segments don't do anything except sit there. > > regards, tom lane > thanks, that did it - I hadn't been vacuuming a rarely used db we have tossed on there too. -- Jeff Trout <[EMAIL PROTECTED]> http://www.jefftrout.com/ http://www.stuarthamm.net/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
