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@xxxxxxxxxxx
