>>>>> On Mon, 19 Feb 2007 15:10:26 -0500, Bill Moran said: > > In response to Martin Simmons <[EMAIL PROTECTED]>: > > > >>>>> On Mon, 19 Feb 2007 08:55:07 -0500, Bill Moran said: > > > > > > On the flip side, running dbcheck periodically is pretty much a > > > requirement > > > for keeping Bacula's database reasonably sized. I have it run once a > > > month > > > in read-only mode via cron and email us the results. When the extra stuff > > > gets significant, I use it to go in and clean up. > > > > I think that is overly pessimistic -- unless you are backing up lots of data > > where the file names or directory names keep changing in the Filename and > > Path > > tables. > > Backup up a server with a bunch of Maildirs, and you'll see this fast enough.
Ah, good point. > Even without that, with 6 servers and 20 workstations being backed up, lots of > files get created, renamed, deleted, on a constant basis. Every few months, > the amount of unreferenced stuff is big enough to warrant cleanup. > > Personally, I don't think a monthly review of the state of the backup system > is overly pessimistic in any way :) > > bacula=> select count(*) from file; > count > ---------- > 19667790 > (1 row) > > bacula=> select count(*) from filename; > count > -------- > 927786 > (1 row) > > bacula=> select count(*) from path; > count > -------- > 655714 > (1 row) That's an interestingly low ratio of filename/path :-) __Martin ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
