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
