Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] Restoring Postgres Dump is very slow with Ubuntu 16.04 - Mailing list pgsql-performance

From Andreas Kretschmer
Subject Re: [PERFORM] Restoring Postgres Dump is very slow with Ubuntu 16.04
Date
Msg-id a9dc820f-f948-644b-a27e-fb72d175becb@a-kretschmer.de
Whole thread Raw
In response to [PERFORM] Restoring Postgres Dump is very slow with Ubuntu 16.04  (Hans Braxmeier <hans.braxmeier@outlook.com>)
List pgsql-performance
Tree view



Am 15.04.2017 um 10:11 schrieb Hans Braxmeier:

Hello,


restoring a dump with Ubuntu 16.04 using postgres.conf default configuration (autovacuum on) takes several hours, with Ubuntu 14.04 only 20 minutes. Turning autovacuum off in Ubuntu 16.04 makes restoring much faster, with 14.04 autovacuum off has nearly no effect. The PG version does not matter. Same results with PG 9.4/9.5/9.6.




Do you have any idea what could cause this effect (what has changed in Ubuntu 16.04?) and should autovaccum be turned on again after restoring the dump? Does autovaccum slow down other Postgres queries?


Autovacuum should always be on. Is the destination database (the whole db-cluster)  new and empty?

Regards, Andreas
-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

pgsql-performance by date:

Previous
From: Hans Braxmeier
Date:
Subject: [PERFORM] Restoring Postgres Dump is very slow with Ubuntu 16.04
Next
From: Dinesh Chandra 12108
Date:
Subject: [PERFORM] Create a materialized view in PostgreSQL which can be access by allthe user account