projects / evergreen / pines.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: e57d480) | 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 15:56:55 +0000 (11:56 -0400)
commit82749860db5cf3b53b4cd5be3395b06ea284efae
tree2ae361add1f6e8325d139b295396ed6df8ec23b0tree
parente57d480a0b47d4e5ab1f060cf772568341877b75commit | 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 (PINES)