Re: pg_upgrade and statistics

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_upgrade and statistics
Дата
Msg-id 18325.1331611947@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_upgrade and statistics  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: pg_upgrade and statistics
Re: pg_upgrade and statistics
Список pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> Copying the statistics from the old server is on the pg_upgrade TODO
> list.  I have avoided it because it will add an additional requirement
> that will make pg_upgrade more fragile in case of major version changes.

> Does anyone have a sense of how often we change the statistics data
> between major versions?

I don't think pg_statistic is inherently any more stable than any other
system catalog.  We've whacked it around significantly just last week,
which might color my perception a bit, but there are other changes on
the to-do list.  (For one example, see nearby complaints about
estimating TOAST-related costs, which we could not fix without adding
more stats data.)
        regards, tom lane


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

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: initdb and fsync
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: Scaling XLog insertion (was Re: Moving more work outside WALInsertLock)