Re: [GENERAL]auto vacuum during restore

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: [GENERAL]auto vacuum during restore
Дата
Msg-id BANLkTimW+HZcDUf4W2J0HYp_o3Jy=q0iRw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL]auto vacuum during restore  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgsql-admin
Дерево обсуждения
On Tue, Apr 26, 2011 at 12:59 PM, Guillaume Lelarge <guillaume@lelarge.info> wrote:
> 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.


So that just means you need some luck of timing.  Not really "part of the process" if you ask me.
 


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


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

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: [GENERAL]auto vacuum during restore
Следующее
От: "Fred Parkinson"
Дата:
Сообщение: pgadmin3 install fails