Hi,
On 2018-08-01 10:24:24 -0400, Tom Lane wrote:
> Rijo Roy <rjo_roy@yahoo.com> writes:
> > Thanks for the advice. Autovacuum is disabled in the environment and I cannot take a call on enabling it back. I
canonly run manual vacuum on the database as the dev team fears autoanalyze changing the query performance. Do you
stillthink 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