Insert of attributes batch table

David Lawley

unread,

Jun 12, 2020, 10:30:28 AM6/12/20

to bareos-users

I have a small backup job, but lots of files

once done, it does the " Insert of attributes batch table with 800001 entries start"

Is there a way to limit this batch size, with this volume of insertions it takes about 4 hours to complete the task, and if there are more there is more wait

My current job is on its 3 round of inserts, currently at about 9 hours, just doing insert of attributes

ideas? Thanks

Brock Palen

unread,

Jun 12, 2020, 11:24:07 PM6/12/20

to David Lawley, bareos-users

Not that I know of. But I had a similar issue. Are you using MySQL? If so switch to Postgres it fixes most issues like this.

The new dbcopy command in the manual will help you migrate.

Sent from my iPhone

Brock Palen

989-277-6075

On Jun 12, 2020, at 10:30 AM, David Lawley <da...@upilab.com> wrote:

--
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 bareos-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/bd843a94-bf01-3a32-a7e4-594cefb86865%40upilab.com.

David Lawley

unread,

Jun 15, 2020, 7:12:52 AM6/15/20

to Brock Palen, bareos-users

PostgreSQL, will investigate. Thanks

Reply all

Reply to author

Forward