> On Feb 13, 2016, at 10:43 AM, Dan Langille <d...@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 d...@langille.org
signature.asc
Description: Message signed with OpenPGP using GPGMail