Change #6788
Category | None |
Changed by | Mike Rylander <mrylander | @gmail.com>
Changed at | Mon 06 Jan 2020 10:23:35 |
Repository | git://git.evergreen-ils.org/Evergreen.git |
Project | Evergreen |
Branch | master |
Revision | 978bd61d500c41995128ef0284ec630dcc6cd376 |
Comments
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>
Changed files
- Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/action.pm