Re: Speeding up pg_upgrade

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Speeding up pg_upgrade
Дата
Msg-id 8486.1512664928@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Speeding up pg_upgrade  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: Speeding up pg_upgrade  (Robert Haas <robertmhaas@gmail.com>)
Re: Speeding up pg_upgrade  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-hackers
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> It seems pretty clear to me that we should somehow transfer stats from
> the old server to the new one.  Shouldn't it just be a matter of
> serializing the MCV/histogram/ndistinct values, then have capabilities
> to load on the new server?

The reason pg_upgrade hasn't done that in the past is not wishing to
assume that the new version does stats identically to the old version.
Since we do in fact add stats or change stuff around from time to time,
that's not a negligible consideration.

            regards, tom lane


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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: Speeding up pg_upgrade
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Signals in a BGW