2008/9/9 Dan Langille <[EMAIL PROTECTED]>: >> >> Algorithm: >> - when you specify "9) Check for orphaned Path records" or "10) Check >> for orphaned Filename records" : >> - verified the existence of the "one-column" index on the column >> PathId (or FilenameId) >> - if the index does not exist, then asked : "Create temporary index? >> (yes/no):" >> - after that dbcheck working as usual >> - temporary index removed. >> >> The patch is attached. >> >> What would you say? > > Separate from the patch: suggest running some large backups, with and > without the index. See the difference in the times for MySQL. That may > help some people decide whether or not they want to run with the index all > the time. >
Yes, and it is. If you answer "No" to the question "Create temporary index? (Yes / no):" it will not create indexes. > > -- > Dan Langille > > BSDCan - The Technical BSD Conference : http://www.bsdcan.org/ > PGCon - The PostgreSQL Conference: http://www.pgcon.org/ > -- with best regards ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
