pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Dan Langille <dan@langille.org>
To: Jeff Janes <jeff.janes@gmail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Running lots of inserts from selects on 9.4.5
Date: Sat, 13 Feb 2016 10:45:46 -0500
Message-ID: <94114DAE-08D1-4DF4-98F2-F167AB34167B@langille.org> (raw)
In-Reply-To: <E4396D5A-BA28-4534-B6E0-D72BB53E7DFC@langille.org>
References: <69012280-1847-426A-8813-D51CA4CC9B02@langille.org>
	<CAMkU=1zUD1GJ9ogHtGLWeLCxy79QJqUUnA4fU92EP_pNFtZZdA@mail.gmail.com>
	<43C0F377-7A27-455A-B695-D3EA92B81128@langille.org>
	<6CB3CC7F-859F-4550-983C-074F3617A90F@langille.org>
	<E4396D5A-BA28-4534-B6E0-D72BB53E7DFC@langille.org>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

> 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 <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@langille.org

Attachments:

  signature.asc (application/pgp-signature, 970B) download

view thread (6+ messages)

Message-ID: <94114DAE-08D1-4DF4-98F2-F167AB34167B@langille.org>
Permalink:  ../94114DAE-08D1-4DF4-98F2-F167AB34167B@langille.org/
Also on:    postgresql.org/message-id/94114DAE-08D1-4DF4-98F2-F167AB34167B@langille.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: dan@langille.org, jeff.janes@gmail.com
  Subject: Re: Running lots of inserts from selects on 9.4.5
  In-Reply-To: <94114DAE-08D1-4DF4-98F2-F167AB34167B@langille.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox