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 after that 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