MySQL to Postgres Conversion

18 views

Skip to first unread message

Brock Palen

unread,

Oct 10, 2019, 5:46:36 PM10/10/19

to bareos-users

Looking to speed up my consolidations (the DB for one mac desktop client takes a few hours and locks the tables CPU bound).

I found on the list some references in 2018. Was there any progress on that?

Thanks

Brock Palen
1 (989) 277-6075
bro...@mlds-networks.com
www.mlds-networks.com
Websites, Linux, Hosting, Joomla, Consulting

Andreas Rogge

unread,

Oct 11, 2019, 2:53:59 AM10/11/19

to bareos...@googlegroups.com

Hi,

Am 10.10.19 um 23:46 schrieb Brock Palen:

> Looking to speed up my consolidations (the DB for one mac desktop client takes a few hours and locks the tables CPU
bound).

you can try to add an index on JobTDate in the Job table. It helps a lot
on MySQL and is in the queue to be included in the schema changes for
the upcoming major release:

CREATE INDEX jobtdate_idx ON Job (JobTDate);
ANALYZE TABLE Job;

> I found on the list some references in 2018. Was there any progress on that?
>

Progress has been made, but nothing that was is really usable has been
produced yet.

Best Regards,
Andreas

--
Andreas Rogge andrea...@bareos.com
Bareos GmbH & Co. KG Phone: +49 221-630693-86
http://www.bareos.com

Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646
Komplementär: Bareos Verwaltungs-GmbH
Geschäftsführer: S. Dühr, M. Außendorf, J. Steffens, Philipp Storz