From: | Hans Braxmeier <hans(dot)braxmeier(at)outlook(dot)com> |
---|---|
To: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Restoring Postgres Dump is very slow with Ubuntu 16.04 |
Date: | 2017-04-15 08:11:16 |
Message-ID: | VI1PR04MB11361A7EE57BD159AD0206BE99040@VI1PR04MB1136.eurprd04.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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.
Time to restore the dump
- Ubuntu 14.04 autovaccuum on: Sa 15. Apr 09:07:41 CEST 2017 - Sa 15. Apr 09:24:09 CEST 2017 -> 17 min
- Ubuntu 14.04 autovaccuum off: Sa 15. Apr 02:41:06 CEST 2017 - Sa 15. Apr 02:58:03 CEST 2017 -> 17 min
- Ubuntu 16.04 autovaccuum on: Sat Apr 15 03:22:07 CEST 2017 - Sat Apr 15 07:45:46 CEST 2017 > 4 hours
- Ubuntu 16.04 autovaccuum off: Sat Apr 15 09:19:20 CEST 2017 - Sat Apr 15 09:55:09 CEST 2017 -> 35 min
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?
Thanks for any help, Hans
PS: My last post "Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow" from yesterday (2017-04-14 23.30:10) was not correct. Sorry
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2017-04-15 13:59:56 | Re: Restoring Postgres Dump is very slow with Ubuntu 16.04 |
Previous Message | Justin Pryzby | 2017-04-15 00:23:22 | self join estimate and constraint exclusion |