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
