Hi,
I switched from Sqlite to Postgresql. Performance was horrible until I
turned fsync off.
I suspect that bacula is inserting data about each file as a seperate
transaction. Something like this:
begin;
insert into file values (...);
commit;
Or actually it is probably just running with autocommit on, which is the
same thing.
What it should be doing, is inserting large amount of files in a single
transaction. Like this;
begin;
insert into file values (...);
insert into file values (...);
insert into file values (...);
insert into file values (...);
(many more)
commit;
That will speed everything up by a huge amount. And it wouldn't be
neccessary to turn fsync off.
Hmm I also notice that there are no foreign keys. Adding them wouldn't
help speeding things up though.
Is there something in bacula that prevents running things in larger
transactions like this?
Baldur
-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server.
Download it for free - -and be entered to win a 42" plasma tv or your very
own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
