Re: pg_clog & vacuum oddness

On Wed, 29 Oct 2003 11:32:12 -0500
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Jeff <threshar@torgo.978.org> 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 <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/