On Jul 8, 2010, at 12:50 PM, Tom Lane wrote: > Richard Yen <rich...@iparadigms.com> writes: >> My concern is that--as in the original post--there were moments where 129 >> WAL files were generated in one minute. Is it plausible that this >> autovacuum could be responsible for this? > > That's not a particularly surprising WAL creation rate for a busy > database. I wouldn't expect autovacuum to cause it by itself, but > that's true only because autovacuum processing is typically throttled > by autovacuum_vacuum_cost_delay. Perhaps you had that set to zero? >
Ah, yes, autovacuum_vacuum_cost_delay = 0 in my config. That explains it--guess I'm playing with knives if I set things that way... --Richard -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
