Hello James, On 02/02/2013 11:18 PM, James Harper wrote: > The manual here > http://www.bacula.org/5.2.x-manuals/en/main/main/Catalog_Maintenance.html#SECTION004292000000000000000 > says I should create an index on File of (JobId, FilenameId, PathId), > while the make_mysql_tables script says it should be (JobId, PathId, > FilenameId). > > Which is it?
Probably a typo in the documentation. For the order, when using PostgreSQL, if you have the JobId and the PathId, PostgreSQL can use this index to retrieve records (ie: list all files of a directory for a given set of jobs, pretty useful). This is also a nice way to have a well ordered index. Bye -- Need professional help and support for Bacula ? Visit http://www.baculasystems.com ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_jan _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
