On 04/08/10, Marc Cousin (cousinm...@gmail.com) wrote: > > Changes to one part of Bacula has to be compatible with all other parts > > of Bacula. For example, given that we support SQLite, PostgreSQL, and > > MySQL, we have to keep each in mind. Yes, it's a compromise.
> Moreover, yes, PostgreSQL is a robust DB. Capable of doing very high end > transactionnal work. But that's not what bacula requires. Bacula requires > very high throughput (some of us have to insert 50 millions rows a day) Touche -- I've been thinking too much of my single server backing itself up. > > The running out of space is a PostgreSQL issue. > I wouldn't say that. I would say that configuring a 10GB /var for the > database filesystem when doing 7TB backups is the issue. Give it more > space and stop wasting time. > ... > I totally agree with Dan : try the insert mode. And don't forget to > post your results back. OK. > > > This is a cludge (with an inefficient correlated subquery!) that could > > > easily miss paths which exist from previous, unrelated backups. A > > > continuous insert process against a job and mediaid simply wouldn't need > > > to do this. > > > > If you want to patch it, we'll certainly look at it. > Yes, so what ? Do you propose doing a transaction for every file > backed up ? It is used as a data dump, because that is what the > catalog is (for the tape part). And we have to be fast when inserting > there, there are some configurations with hundreds of client > spooling??? not juste one backup. Fair enough. Thanks for your comments. Regards Rory -- Rory Campbell-Lange r...@campbell-lange.net ------------------------------------------------------------------------------ The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
