Hi, On 2018-08-01 10:24:24 -0400, Tom Lane wrote: > Rijo Roy <rjo_roy@xxxxxxxxx> 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
