>>> Tom Lane <tgl@xxxxxxxxxxxxx> 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
