And potentially to tune down the number kept by modifying the appropriate freeze parameter for 8.1 (I'm not sure of the details), so that it keeps perhaps 20MB or so rather than 50MB.
On Wed, Sep 10, 2008 at 10:47 AM, Kevin Grittner < [EMAIL PROTECTED]> wrote: > >>> Tom Lane <[EMAIL PROTECTED]> wrote: > > > The expected behavior (in 8.2 and newer) is to maintain about > > autovacuum_freeze_max_age transactions' worth of clog; which is to > say > > about 50MB at the default settings. > > The active database I checked, where it didn't go all the way back to > 0000, had 50 MB of files; so I guess it is working as intended. > > It sounds like the advice to the OP that running VACUUM FREEZE on all > databases to clean up the files was off base? > > -Kevin > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance >
