Re: About "Cost-based Vacuum Delay"

Ilyeop Yi wrote:
> Currently, I am working with a workload that is mostly insert and update, and its performance suffers from
autovacuum.
> 
> I've adjusted parameters such as vacuum_cost_delay and vacuum_cost_limit, but they have no significant effect.
> 
> So, I would like to find a way to pause a running vacuum during bursty insert/update period and resume the vacuum
afterthat period.
 
> 
> Is there such a way?

Please keep the list copied.

You can do

   ALTER TABLE mytab SET (autovacuum_enabled = off);

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com