| From: | Dan Langille <dan(at)langille(dot)org> |
|---|---|
| To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Running lots of inserts from selects on 9.4.5 |
| Date: | 2016-02-13 15:45:46 |
| Message-ID: | 94114DAE-08D1-4DF4-98F2-F167AB34167B@langille.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> On Feb 13, 2016, at 10:43 AM, Dan Langille <dan(at)langille(dot)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(at)langille(dot)org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jaime soler | 2016-02-16 12:52:49 | Re: Primary key index suddenly became very slow |
| Previous Message | Dan Langille | 2016-02-13 15:43:30 | Re: Running lots of inserts from selects on 9.4.5 |