Home - Waterfall Grid T-Grid Console Builders Recent Builds Buildslaves Changesources - JSON API - About

Change #6788

Category None
Changed by Mike Rylander <mrylanderohnoyoudont@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