projects / evergreen / tadl.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 9c7b165) | patch
LP#1374091: Redefine view to help PG make better plans
authorMike Rylander <miker@esilibrary.com>
Thu, 25 Sep 2014 18:34:20 +0000 (14:34 -0400)
committerBen Shum <bshum@biblio.org>
Thu, 9 Oct 2014 16:00:44 +0000 (12:00 -0400)
commit6d5a70a4a2f625ee51bc55db35ebeca5d8039147
tree19a4756107ed428cc402e427e691993aab671fc7tree
parent9c7b16588cbad34b58c904ce38ff34eb5d7653decommit | diff
LP#1374091: Redefine view to help PG make better plans

The metabib.record_attr_flat view previously pulled its data
through several other intermediate views.  While this improves
maintenance overhead, it ends up being an optimization fence
for certain data sets.  So, we pull the logic from the leaf
views up into the main view.  And, poof, 2 orders of magnitude
speedup on large data sets.

Signed-off-by: Mike Rylander <miker@esilibrary.com>
Signed-off-by: Ben Shum <bshum@biblio.org>
Open-ILS/src/sql/Pg/030.schema.metabib.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.record_attr_flat_speedup.sql [new file with mode: 0644] blob
Evergreen working repo (TADL)