Ofer Israeli <[email protected]> writes:
> During our testing we see that the table size increases substantially. When
> looking at the autovacuum log, set with default configuration, it seems that
> it ran for around 60 seconds (see below and note that this was a 1-minute
> test, i.e. only 100 updates)!
autovacuum is intended to run fairly slowly, so as to not consume too
much resources. If you think it's too slow you can adjust the
autovacuum_cost tunables.
> When setting a higher cost for the autovacuum, tried values of 2000, it ran
> for even longer: ~400 seconds!
That's the wrong direction, no?
regards, tom lane
--
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
