Re: pg_clog & vacuum oddness

On Wed, 29 Oct 2003 11:32:12 -0500
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Jeff <threshar(at)torgo(dot)978(dot)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(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/