Re: Running lots of inserts from selects on 9.4.5

[Dan Langille <dan@xxxxxxxxxxxx>]

On Feb 13, 2016, at 10:43 AM, Dan Langille <dan@xxxxxxxxxxxx> 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.

The query plans: https://twitter.com/DLangille/status/698528182383804416

-- 

Dan Langille - BSDCan / PGCon

dan@xxxxxxxxxxxx

Attachment: signature.asc
Description: Message signed with OpenPGP using GPGMail