In response to Martin Simmons <[EMAIL PROTECTED]>: > >>>>> 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 :-)
Never really thought about it, but it does seem a little odd. It's probably an indicator of the fact that we're a devel shop. Most of our users have copies of the software project in their home directory, so lots of new paths, but copies of the same files (filenames) -- Bill Moran Collaborative Fusion Inc. ------------------------------------------------------------------------- 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
