On Fri, Mar 18, 2011 at 9:07 PM, Phoenix Kiula <phoenix.kiula@xxxxxxxxx> wrote: > autovacuum = on > autovacuum_vacuum_cost_delay = 20 > > vacuum_cost_delay = 20 > vacuum_cost_limit = 600 > > autovacuum_naptime = 10 also, if vacuum can't keep up you can increase the vacuum cost limit, and lower the cost delay. Anything above 1ms is still quite a wait compared to 0. And most systems don't have the real granularity to go that low anyway, so 5ms is about as low as you can go and get a change before 0. Also, if you've got a lot of large relations you might need to increase the max workers as well. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
