Analyze and vaccum

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.html

https://www.postgresql.org/docs/11/sql-analyze.html

https://www.postgresql.org/docs/11/sql-vacuum.html

--
Adrian Klaver
adrian.klaver@aklaver.com