Re: pg_clog & vacuum oddness - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_clog & vacuum oddness
Date
Msg-id 5274.1067445132@sss.pgh.pa.us
Whole thread Raw
In response to pg_clog & vacuum oddness  (Jeff <threshar@torgo.978.org>)
Responses Re: pg_clog & vacuum oddness  (Jeff <threshar@torgo.978.org>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Jeff
Date:
Subject: pg_clog & vacuum oddness
Next
From: Jeff
Date:
Subject: Re: pg_clog & vacuum oddness