| From: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Restoring Postgres Dump is very slow with Ubuntu 16.04 |
| Date: | 2017-04-15 13:59:56 |
| Message-ID: | a9dc820f-f948-644b-a27e-fb72d175becb@a-kretschmer.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dinesh Chandra 12108 | 2017-04-17 17:00:14 | Create a materialized view in PostgreSQL which can be access by all the user account |
| Previous Message | Hans Braxmeier | 2017-04-15 08:11:16 | Restoring Postgres Dump is very slow with Ubuntu 16.04 |