Insert of attributes batch table with 800001 entries start

[Wforum Wforum]

Hi,

We have a full backup (~500GB) with approx. 11 Million files.

The job is back-upped on tape and once done, it does the " Insert of attributes batch table with 800001 entries start"

But the job still not ended.

Any idea why? We are using postgresql as database

JobLog

2020-07-02 11:38:02    bareos-dir JobId 17: Insert of attributes batch table done
2020-07-02 11:37:44    bareos-dir JobId 17: Insert of attributes batch table with 800001 entries start
2020-07-02 10:18:14    bareos-dir JobId 17: Insert of attributes batch table done
2020-07-02 10:17:54    bareos-dir JobId 17: Insert of attributes batch table with 800001 entries start
2020-07-02 08:22:50    bareos-dir JobId 17: Insert of attributes batch table done
2020-07-02 08:22:29    bareos-dir JobId 17: Insert of attributes batch table with 800001 entries start
2020-07-02 05:06:14    bareos-dir JobId 17: Insert of attributes batch table done
2020-07-02 05:05:52    bareos-dir JobId 17: Insert of attributes batch table with 800001 entries start
2020-07-02 01:37:03    bareos-dir JobId 17: Insert of attributes batch table done
2020-07-02 01:36:41    bareos-dir JobId 17: Insert of attributes batch table with 800001 entries start
2020-07-01 21:54:58    bareos-dir JobId 17: Insert of attributes batch table done
2020-07-01 21:54:36    bareos-dir JobId 17: Insert of attributes batch table with 800001 entries start
2020-07-01 18:50:53    bareos-dir JobId 17: Insert of attributes batch table done
2020-07-01 18:50:33    bareos-dir JobId 17: Insert of attributes batch table with 800001 entries start
2020-07-01 16:07:40    bareos-dir JobId 17: Insert of attributes batch table done
2020-07-01 16:07:19    bareos-dir JobId 17: Insert of attributes batch table with 800001 entries start
2020-07-01 13:23:25    bareos-dir JobId 17: Insert of attributes batch table done
2020-07-01 13:23:04    bareos-dir JobId 17: Insert of attributes batch table with 800001 entries start
2020-07-01 10:23:56    bareos-dir JobId 17: Insert of attributes batch table done
2020-07-01 10:22:53    bareos-dir JobId 17: Insert of attributes batch table with 800001 entries start
2020-06-30 21:30:53    bareos-dir JobId 17: Insert of attributes batch table done
2020-06-30 21:30:27    bareos-dir JobId 17: Insert of attributes batch table with 800001 entries start
2020-06-30 18:26:31    bareos-dir JobId 17: Insert of attributes batch table done
2020-06-30 18:26:07    bareos-dir JobId 17: Insert of attributes batch table with 800001 entries start
2020-06-30 13:12:17    bareos-sd JobId 17: Wrote label to prelabeled Volume "Name" on device "Drive-1" (/dev/tape/by-id/scsi-xxx)
2020-06-30 13:12:16    bareos-dir JobId 17: Start Backup JobId 17, Job=full.2020-06-30_13.12.14_16

Many thanks!!

[David Lawley]

ask this question a few weeks ago.  Its just slow.  There were a few suggestions, but I have been swamped with PCI compliance task from our bank and now been able to get refocused on it

--
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/7ae076ea-8012-496d-818e-593a41701e1fo%40googlegroups.com.

[Kaspar Hauser]

What are your hardware specs?

did you tried this?
https://pgtune.leopard.in.ua/#/
https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

[W Forum W]

Thanks, in the meantime the job finished.

As you can see the task took 2 days.

Can you give an update on the list if you found out some more?

To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/026b3755-bd75-3cb5-a033-3cffc2d38189%40upilab.com.

[W Forum W]

Thanks, I will have a look to tune our Postgresql Server

--
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/9a207aed-01f5-47b6-8dfe-41bfdbee6868n%40googlegroups.com.