Analyze and vaccum

Поиск
Список
Период
Сортировка
От Sonam Sharma
Тема Analyze and vaccum
Дата
Msg-id CAM-M3Tkgrr+G1BoPPpFq79CVNpW_Y+5O403nvNT_rOW6amw7Lw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Analyze and vaccum  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
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 .

В списке pgsql-general по дате отправления:

Предыдущее
От: Imre Samu
Дата:
Сообщение: Re: Regarding db dump with Fc taking very long time to completion
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Analyze and vaccum