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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match