BACULA – How To reduce DbCheck Time
I added the following indexes:
CREATE INDEX File_JobId_idx ON File(JobId); CREATE INDEX File_PathId_idx ON File(PathId); CREATE INDEX File_FilenameId_idx ON File(FilenameId); CREATE INDEX Path_PathId_idx ON Path(PathId); CREATE INDEX Job_FileSetId_idx ON Job(FileSetId); CREATE INDEX Job_ClientId_idx ON Job(ClientId); CREATE INDEX File_FilenameIdPathId_idx ON File(FilenameId,PathId);
This reduced dbcheck time from >24 hours to a few *seconds*. Adding the
indexes themselves only took up to 15 seconds.
