This post is about indexes which have low usage. I am not proposing 
change.

After reading this post:

   
http://www.databasesoup.com/2014/05/new-finding-unused-indexes-query.html

I decided to try it on my Bacula server, and I've put the results here:

   https://gist.github.com/dlangille/cbd6ee13bab80399aaf7

In short, these indexes are never used:

tablename     | indexname
jobhisto      | jobhisto_idx
fileset       | fileset_name_idx
pathhierarchy | pathhierarchy_ppathid

These indexes are rarely read, but I suspect they are very useful for 
restores:

file          | file_jpfid_idx
file          | file_pathid_idx
file          | file_filenameid_idx
job           | job_name_idx
media         | media_idx

-- 
Dan Langille - http://langille.org/

------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.  Get 
unparalleled scalability from the best Selenium testing platform available.
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users