projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: a4dd07f) | 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)
committerMike Rylander <mrylander@gmail.com>
Sun, 28 Sep 2014 19:38:43 +0000 (15:38 -0400)
commitb6391eb441cb368d555883c08e71c14f626dae25
treee0fe17f51c92b2d36d6988bb84b45d6088fb3d64tree
parenta4dd07fe7c8cca910941ba8abbc1a5f656063229commit | 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>
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 ILS