Re: auto vacuum during restore

Поиск
Список
Период
Сортировка
Искать
От
Guillaume Lelarge
Тема
Re: auto vacuum during restore
Дата
Msg-id
4DB6F9D5.4030504@lelarge.info
Ответ на
Список
Дерево обсуждения
auto vacuum during restore Willy-Bas Loos <willybas@gmail.com>
Re: auto vacuum during restore Vick Khera <vivek@khera.org>
Re: auto vacuum during restore Guillaume Lelarge <guillaume@lelarge.info>
Re: auto vacuum during restore Vick Khera <vivek@khera.org>
Le 26/04/2011 18:38, Vick Khera a écrit :
> On Tue, Apr 26, 2011 at 11:36 AM, Willy-Bas Loos  wrote:
> 
>> I don't get it, they should have been analyzed at restore, should they not?
>>
> 
> I do not believe analyze is part of the restore process.  You must
> explicitly run it.
> 

That's almost true. If autovacuum is on, it can start an ANALYZE on the
big tables.

Depends of course on your settings (autovacuum on, stats collector on, etc.)


-- 
Guillaume
 http://www.postgresql.fr
 http://dalibo.com
В списке pgsql-general по дате отправления
От: Diogo Melo
Дата:
От: Vick Khera
Дата:
Сообщение: Re: auto vacuum during restore
FAQ