Greg Smith <[EMAIL PROTECTED]> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
