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