Re: Clarification on using pg_upgrade

Поиск
Список
Период
Сортировка
От Tory M Blue
Тема Re: Clarification on using pg_upgrade
Дата
Msg-id CAEaSS0bi0oAk2u615P-WmtLj3XfvAeBBLgO05nxyK5tD7Pui5Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Clarification on using pg_upgrade  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Ответы Re: Clarification on using pg_upgrade  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Список pgsql-performance
Thanks to all that responded

I successfully upgraded 800GB DB with pg_upgrade in about 2 hours.
This would have taken 2 days to dump/restore.

Slon is also starting to not be viable as it takes some indexes over 7
hours to complete. So this upgrade path seemed to really be nice.

Not sure how I can incorporate with my slon cluster, I guess that will
be the next thing I research.

Appreciate the responses and assistance.

Tory


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

Предыдущее
От: Moreno Andreo
Дата:
Сообщение: Re: [SPAM] Re: Architectural question
Следующее
От: Wei Shan
Дата:
Сообщение: Query not using Index