Greg Smith <gsmith@gregsmith.com> 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