LP#1855329: Hold shelf query speed problem user/miker/lp-1855329-hold_shelf_speed
authorMike Rylander <mrylander@gmail.com>
Thu, 5 Dec 2019 20:12:57 +0000 (15:12 -0500)
committerMike Rylander <mrylander@gmail.com>
Thu, 5 Dec 2019 20:12:57 +0000 (15:12 -0500)
commit216b6e1030bce8cea1054ca990ec4345fdb5f6e8
tree0786b537a6aed10232bd9f106bd52ebeb3a233dd
parentf643bea30c2a2253d74636e1e33ec5c2aa78bd4c
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>
Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/action.pm