Greg Smith <gsmith@xxxxxxxxxxxxx> writes: > On Tue, 2 Sep 2008, Duan Ligong wrote: >> - Can we controll the maximum number of the clog files? > The reference Alvaro suggested at > http://www.postgresql.org/docs/8.3/interactive/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND > goes over that. If you reduce autovacuum_freeze_max_age, that reduces the > expected maximum size of the clog files. Duan's first post stated that he is running 8.1, which I believe had a quite different rule for truncating pg_clog --- it definitely has not got the parameter autovacuum_freeze_max_age. Too tired to go reread the 8.1 code right now, but don't quote 8.3 docs at him, 'cause they're not too relevant. regards, tom lane
