Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow - Mailing list pgsql-performance

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
Whole thread Raw
In response to [PERFORM] Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow  (Hans Braxmeier <hans.braxmeier@outlook.com>)
List pgsql-performance
Tree view 
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 by date:

Previous
From: Hans Braxmeier
Date:
Subject: [PERFORM] Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow
Next
From: Justin Pryzby
Date:
Subject: [PERFORM] self join estimate and constraint exclusion