Hi, On 2018-08-01 10:24:24 -0400, Tom Lane wrote: > Rijo Roy <rjo_...@yahoo.com> writes: > > Thanks for the advice. Autovacuum is disabled in the environment and I > > cannot take a call on enabling it back. I can only run manual vacuum on the > > database as the dev team fears autoanalyze changing the query performance. > > Do you still think we don't need to take any actions. > > IMO, the action you need to take is enabling autovacuum. We've > seen many many people go down the path you are taking, and it's > generally led to no good in the end. Manual vacuuming tends > to miss stuff, and it cannot react adequately to activity spikes.
But it shouldn't matter here, autovacuum will start regardless, no? Greetings, Andres Freund
