Re: Running lots of inserts from selects on 9.4.5

On Feb 13, 2016, at 10:43 AM, Dan Langille <dan@langille.org> wrote:

Today I tackled the production server.  After discussion on the Bacula devel mailing list (http://marc.info/?l=bacula-devel&m=145537742804482&w=2)

I compared my schema to the stock schema provided with Bacula.  Yes, I found 

extra indexes.  I saved the existing schema and proceeded to remove the indexes

from prod not found in the default.

The query time went from 223 minute to 4.5 minutes.  That is 50 times faster.