Re: 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