[PERFORM] Restoring Postgres Dump is very slow with Ubuntu 16.04

2017-04-15 Thread 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 no

Re: [PERFORM] Restoring Postgres Dump is very slow with Ubuntu 16.04

2017-04-15 Thread Andreas Kretschmer
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 autovac