Ofer Israeli <of...@checkpoint.com> 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 (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance