pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow
2+ messages / 2 participants
[nested] [flat]
* Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow
@ 2017-04-14 23:30 Hans Braxmeier <hans.braxmeier@outlook.com>
2017-04-14 23:40 ` Re: Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Hans Braxmeier @ 2017-04-14 23:30 UTC (permalink / raw)
To: pgsql-performance
Hello,
after updating my server to Postgres 9.5 (or 9.6) I tried to import PG 9.4 dumps and/or to restore 9.5/9.6 dumps:
pg_dump testdb > db.sql
psql -d testdb -f db.sql
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 same system (even if I make a PG 9.5/9.6 dumps and try to restore this one)!
I also tried to restore dumps with the original PG 9.4/9.5.9.6 configuration as well as with different options like increasing max_wal_size in 9.5/9.6. e.g.
Do I miss a specific option in 9.5/9.6 which may be different to 9.4? If I turn off autovacuum (9.5/9.6) it's faster - but not as fast as with PG 9.4.
Example Log 9.5/9.6:
LOG: duration: 278349.128 ms statement: COPY test (id, ...)
LOG: duration: 646487.952 ms statement: ALTER TABLE ONLY test ...
The same with creating index... It takes hours with PG 9.5./9.6!
Thanks, Hans
<http://www.maps-for-free.com/;
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow
2017-04-14 23:30 Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow Hans Braxmeier <hans.braxmeier@outlook.com>
@ 2017-04-14 23:40 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2017-04-14 23:40 UTC (permalink / raw)
To: Hans Braxmeier <hans.braxmeier@outlook.com>; +Cc: 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 same system (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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2017-04-14 23:40 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-04-14 23:30 Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow Hans Braxmeier <hans.braxmeier@outlook.com>
2017-04-14 23:40 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox