On Wed, Sep 10, 2008 at 8:58 AM, Kevin Grittner <[EMAIL PROTECTED]> wrote: >> "Matt Smiley" <[EMAIL PROTECTED]> wrote: >> Alvaro Herrera wrote: >>> Move the old clog files back where they were, and run VACUUM FREEZE > in >>> all your databases. That should clean up all the old pg_clog files, > if >>> you're really that desperate. >> >> Has anyone actually seen a CLOG file get removed under 8.2 or 8.3? > > Some of my high-volume databases don't quite go back to 0000, but this > does seem to be a problem. I have confirmed that VACUUM FREEZE on all > but template0 (which doesn't allow connections) does not clean them > up. No long running transactions are present.
I have a pretty high volume server that's been online for one month and it had somewhere around 53, going back in order to 0000, and it was recently vacuumdb -az 'ed. Running another one. No long running transactions, etc... -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
