Francisco Reyes <lists@stringsutils.com> writes:
> I think I am going to try increasing wal_buffers
That will help not at all, if the problem is too-short transactions
as it sounds to be. You really need to pester the authors of bacula
to try to wrap multiple inserts per transaction. Or maybe find some
other software that can do that, if they are uninterested in supporting
anything but mysql.
regards, tom lane