On Fri, Mar 18, 2011 at 9:07 PM, Phoenix Kiula <phoenix.kiula@gmail.com> 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.