]> git.evergreen-ils.org Git - Evergreen.git/commit
projects / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: bd5fa9f) | 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:58 +0000 (12:00 -0400)
commita6a8393879f8f39319661f765dbc31e8d83f042e
tree875949c0649ff569ab42a75993c408cd5a5b953ctree
parentbd5fa9fcade4de73a4a504d407ca6899066f21bfcommit | 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 ILS