Re: [PERFORM] Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PERFORM] Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow
Дата
Msg-id 20571.1492213258@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [PERFORM] Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow  (Hans Braxmeier <hans.braxmeier@outlook.com>)
Список pgsql-performance
Дерево обсуждения 
Hans Braxmeier <hans.braxmeier@outlook.com> writes:
> Restoring these dumps in PG 9.4 takes less than 20 minutes, restoring them in PG 9.5/9.5 takes several hours on the
samesystem (even if I make a PG 9.5/9.6 dumps and try to restore this one)! 

Can you provide a test case demonstrating this sort of slowdown?

            regards, tom lane

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

Предыдущее
От: Hans Braxmeier
Дата:
Сообщение: [PERFORM] Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow
Следующее
От: Justin Pryzby
Дата:
Сообщение: [PERFORM] self join estimate and constraint exclusion