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

From: Tom Lane
Subject: Re: [PERFORM] Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow
Date: ,
Msg-id: 20571.1492213258@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: [PERFORM] Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow  (Hans Braxmeier)
List: 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 by date:

From: Justin Pryzby
Date:
Subject: [PERFORM] self join estimate and constraint exclusion
From: Hans Braxmeier
Date:
Subject: [PERFORM] Restoring Postgres Dump is very slow with Ubuntu 16.04