On Tuesday 25 October 2005 15:08, Volker Sauer wrote: > > Well, something is wrong here, you should have an index on JobId as follows: > Yes, and that's the solution! The missing index on JobId make the SQL > with "... where JobID=...." painfully slow! > I checked the source and the debian package and this index is included > by default. I have no idea why it's missing on my database. I'm creating > it right now (takes some time)!
Hi Volker, We're suffering from exactly the same problem. Could you describe how to add the missing index? Can it be done while the server is running? -Sebastian -- Sebastian Stark -- http://www.kyb.tuebingen.mpg.de/~stark Max Planck Institute for Biological Cybernetics ------------------------------------------------------- This SF.Net email is sponsored by the JBoss Inc. Get Certified Today * Register for a JBoss Training Course Free Certification Exam for All Training Attendees Through End of 2005 Visit http://www.jboss.com/services/certification for more information _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
