On 10/16/19 5:32 AM, Sonam Sharma wrote:
> How auto vaccum and vaccum are different ?
> How analyze and auto analyze are different ?
>
> We were running load on a table which yesterday took 3 mins and today it
> took 30 mins. The autovaccum and autoanalyze are happening daily . But
> the manual vaccum and analyze ran on 26th.
> Can someone please help how these are different and if it help if I run
> a vaccum and analyze on table .
The docs will tell you:
https://www.postgresql.org/docs/11/routine-vacuuming.htmlhttps://www.postgresql.org/docs/11/sql-analyze.htmlhttps://www.postgresql.org/docs/11/sql-vacuum.html
--
Adrian Klaver
adrian.klaver@aklaver.com