Обсуждение: Analyze and vaccum
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 .
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