From: Henrik Cednert (Filmlance) [mailto:henrik.cedn...@filmlance.se]
Sent: Tuesday, November 21, 2017 11:37 AM
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.
cto | compositor
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.