LP#1855329: Hold shelf query speed problem
authorMike Rylander <mrylander@gmail.com>
Thu, 5 Dec 2019 20:12:57 +0000 (15:12 -0500)
committerChris Sharp <csharp@georgialibraries.org>
Wed, 19 Aug 2020 15:07:36 +0000 (11:07 -0400)
commita7a45bdeee59c9367fabd59b92ebd47e4e85d78d
treee1c803d85c2d93536856b64a11989a1da8b7c29d
parentbb687d2af9d2fbbefae496e219f82832be360e74
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