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)
Список: pgsql-performance

Hans Braxmeier <> 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 по дате сообщения:

От: Justin Pryzby
Дата:
Сообщение: [PERFORM] self join estimate and constraint exclusion
От: Hans Braxmeier
Дата:
Сообщение: [PERFORM] Restoring Postgres Dump is very slow with Ubuntu 16.04