>>>>> On Wed, 06 Jan 2010 11:37:18 +0100, Marek Simon said: > > Hi, > I do some experiments with bacula database and I found that there is no > foreign key constraint between jobmedia and job, jobmedia and media, job > and file and many similar logicaly connected tables. Why? Constraints > prevent arising void references (File with empty job, File with empty > filename, jobmedia record with empty job or media) > I have bacula-dir version 2.4.4, postgres variant, and postgres 8.3, > default instalation.
Bacula inserts huge numbers of records into the File table during backups, so any constraints on that table could be very bad for performance. __Martin ------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
