Re: analyze after a database restore?

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: analyze after a database restore?
Дата
Msg-id 061601c2decd$e9a14f00$6500a8c0@fhp.internal
обсуждение исходный текст
Ответ на analyze after a database restore?  (mlw <pgsql@mohawksoft.com>)
Список pgsql-hackers
> Although I suggested doing a single unconditional ANALYZE at the end
> of the script, second thought leads me to think the per-table ANALYZE
> (probably issued right after the table's data-load step) might be
> better.  That way you'd not have any side-effects on already-existing
> tables in the database you are loading to.  OTOH, that way would leave
> the system catalogs un-analyzed, which might be bad.

How about adding an ANALYZE SCHEMA pg_catalog; option :)

Chris




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

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: [PERFORM] Index File growing big.
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Brain dump: btree collapsing