Ribi Roland wrote: > With spooling it takes arround 10-20min to spool data and write them down to > tape at 2MB/s. But the save of the attributes (writing to the catalog) needs > 2h or more!
Looks like the catalog database is underperforming, although maybe 2h is reasonable if you have millions of tiny files (which will be relatively quick to back up, but will take a long time to record in the catalog). > I tried many combinations and recompiled bacula also with Postgres 8.1, > Postgres 8.0, with CFLAGS=-O2/CXXFLAGS=-O2.... > > I compiled it with gcc 3.4.4, which I compiled myself, because on solaris 10 > there is'nt any binary distribution. I would recompile as a last resort, not as a first one... > I think that there are 2 Problems, one is the performance of Bacula or > Postgres itself Postgres, by default, does an fsync (or fdatasync, can't remember) after every write operation. This can kill performance, especially when you don't use transactions (bacula doesn't). Since the bacula database is backed up, and since it can be recreated with bscan, I think I would be happy turning the fsync behaviour off and leaving my database open to corruption in the event of a system crash or power loss. This information, and a lot more, can be found in the Postgresql performance tuning FAQ, linked to from the Postgresql website. > and also some problems with the tape. I did'nt get more > then 2.6Mb/s with the ufsdump from solaris. Are the only devices on the SCSI bus the drive and the controller? Not knowing anything about Solaris, I don't know what you can do with the OS to query/test the bus performance. -- Russell Howe [EMAIL PROTECTED] ------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
