Postgres Pro
Downloads
Home   >   mailing lists

Re: Running lots of inserts from selects on 9.4.5 - Mailing list pgsql-performance

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
Whole thread Raw
In response to Re: Running lots of inserts from selects on 9.4.5  (Dan Langille <dan@langille.org>)
List pgsql-performance
Tree view
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.


-- 
Dan Langille - BSDCan / PGCon

Attachment

pgsql-performance by date:

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