Re: REINDEX takes half a day (and still not complete!)

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