Postgres Pro
Downloads
Home   >   mailing lists

RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade - Mailing list pgsql-performance

From Igor Neyman
Subject RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
Date
Msg-id CY1PR17MB045826A08D80CDE3EB585A6CDA230@CY1PR17MB0458.namprd17.prod.outlook.com
Whole thread Raw
In response to Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade  ("Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se>)
Responses Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade  ("Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se>)
List pgsql-performance
Tree view

 

From: Henrik Cednert (Filmlance) [mailto:henrik.cednert@filmlance.se]
Sent: Tuesday, November 21, 2017 11:37 AM
To: pgsql-performance@lists.postgresql.org
Subject: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade

 

Attention: This email was sent from someone outside of Perceptron. Always exercise caution when opening attachments or clicking links from unknown senders or when receiving unexpected emails.

 

RAID6. Doing disk test I have 1000MB/sec write and 1200MB/sec read. 


--
Henrik Cednert
cto | compositor

Filmlance International
mobile [ + 46 (0)704 71 89 54 ]
skype  [ cednert ]


_________________________________________________________________________________________________

 

Okay, I was kind of wrong about 40GB.  That’s the size of your compressed backup files, not the size of your databases.

May be your dbs are “bloated”?

You could try VACUUM FULL on your databases, when there is no other activity.

 

Igor Neyman

pgsql-performance by date:

Previous
From: Shaul Dar
Date:
Subject: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
Next
From: "Henrik Cednert (Filmlance)"
Date:
Subject: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade