]> git.evergreen-ils.org Git - Evergreen.git/commit
LP#1855329: Hold shelf query speed problem
authorMike Rylander <mrylander@gmail.com>
Thu, 5 Dec 2019 20:12:57 +0000 (15:12 -0500)
committerGalen Charlton <gmc@equinoxinitiative.org>
Mon, 6 Jan 2020 15:24:06 +0000 (10:24 -0500)
commit402660642396a9f13ecc6206b1ab2e3db4c4de8a
treeab91f9108e63860ef48c31a58fb56a9c7781d939
parent640f7aeed4a6a2262921fef2e0cd6f184a0f0415
LP#1855329: Hold shelf query speed problem

In bug 1827250 I suggested Jason Stephenson look at an alternate SQL
formulation to solve the original problem. He did, and deemed it faster,
so went with that. Unfortunately, on PG 9.6, we're seeing some data sets
that decide on a /very/ poor plan for the wide-hold query with the
solution as implemented, but the original suggestion from Jason works
fine.

In the face of evidence controverting my thought that giving PG more
options for planning is better in this case, this commit moves to his
original query change.

Signed-off-by: Mike Rylander <mrylander@gmail.com>
Signed-off-by: Jason Stephenson <jason@sigio.com>
Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>
Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/action.pm