Re: Running lots of inserts from selects on 9.4.5

From: Dan Langille
Subject: Re: Running lots of inserts from selects on 9.4.5
Date: ,
Msg-id: 94114DAE-08D1-4DF4-98F2-F167AB34167B@langille.org
(view: Whole thread, Raw)
In response to: Re: Running lots of inserts from selects on 9.4.5  (Dan Langille)
List: pgsql-performance

Tree view

Running lots of inserts from selects on 9.4.5  (Dan Langille, )
 Re: Running lots of inserts from selects on 9.4.5  (Jeff Janes, )
  Re: Running lots of inserts from selects on 9.4.5  (Dan Langille, )
   Re: Running lots of inserts from selects on 9.4.5  (Dan Langille, )
    Re: Running lots of inserts from selects on 9.4.5  (Dan Langille, )
     Re: Running lots of inserts from selects on 9.4.5  (Dan Langille, )

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


-- 
Dan Langille - BSDCan / PGCon

Attachment

pgsql-performance by date:

From: Dan Langille
Date:
Subject: Re: Running lots of inserts from selects on 9.4.5
From: jaime soler
Date:
Subject: Re: Primary key index suddenly became very slow