Hi,
after applying
/usr/bin/psql -d bareos -c "REINDEX DATABASE bareos"
/usr/bin/psql -d bareos -c "VACUUM"
/usr/bin/psql -d bareos -c "ANALYZE"
as user postgres, I now get
bareos-sd JobId 58569: Despooling elapsed time = 00:03:28, Transfer
rate = 303.3 M Bytes/second
again.
@Chris: Can you confirm this? Please take care you have enough space,
reindex will take about twice the space you had before....
Regards,
Dennis
Am 04.01.2018 um 15:26 schrieb Dennis Benndorf:
Interesting point, here are my numbers:
_/All the same server and partition in october:/_
bareos-sd JobId 38400: Despooling elapsed time = 00:03:47, Transfer
rate = 303.5 M Bytes/second
bareos-sd JobId 38216: Despooling elapsed time = 00:14:14, Transfer
rate = 224.6 M Bytes/second
bareos-sd JobId 36893: Despooling elapsed time = 00:02:43, Transfer
rate = 262.4 M Bytes/second
_/In november directly before upgrade to 17.2-RC/_
bareos-sd JobId 44671: Despooling elapsed time = 00:02:42, Transfer
rate = 325.9 M Bytes/second
bareos-sd JobId 44488: Despooling elapsed time = 00:03:40, Transfer
rate = 318.7 M Bytes/second
bareos-sd JobId 44305: Despooling elapsed time = 00:24:04, Transfer
rate = 210.7 M Bytes/second
_/In november directly after upgrade to 17.2-RC/_
bareos-sd JobId 45580: Despooling elapsed time = 00:04:35, Transfer
rate = 254.4 M Bytes/second
bareos-sd JobId 45761: Despooling elapsed time = 00:06:32, Transfer
rate = 213.1 M Bytes/second
bareos-sd JobId 45943: Despooling elapsed time = 00:09:12, Transfer
rate = 213.0 M Bytes/second
_/Last three Incremental jobs after upgrade to 17.2.4 on 02.01.2018:/_
bareos-sd JobId 58397: Despooling elapsed time = 00:04:59, Transfer
rate = 174.5 M Bytes/second
bareos-sd JobId 58227: Despooling elapsed time = 00:12:03, Transfer
rate = 181.3 M Bytes/second
bareos-sd JobId 55354: Despooling elapsed time = 00:08:18, Transfer
rate = 155.1 M Bytes/second
So indeed it seems to got slower.
Where there differences between the RC and the release?
After installation of RC I noticed a slow database, so I ran ANALYSE
and VACUUM to postgres mainly because bareos-webui was unusable slow....
Regards,
Dennis
Am 04.01.2018 um 14:37 schrieb Jörg Steffens:
I have no explanation for this. The changes done to bareos should no
have affected this. If have been database performance improvements mostly.
Has anybody else made similar experiences after upgrading to bareos-17.2.4?
On 28.12.2017 at 16:50 wrote Chris Sheaves:
I re-ran the update script and tried again with no change. It look like
despooling speed took the greatest hit. Previously
bareos-sd JobId 739: Despooling elapsed time = 00:11:16, Transfer rate = 73.96
M Bytes/second
...but now...
bareos-sd JobId 902: Despooling elapsed time = 00:48:07, Transfer rate = 14.83
M Bytes/second
This is all the same hardware with no other changes to the environment.
--
You received this message because you are subscribed to the Google Groups
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
For more options, visit https://groups.google.com/d/optout.