Followup to bug 1827250, hold shelf issues
Bug #1855329 reported by
Mike Rylander
This bug affects 3 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Fix Released
|
High
|
Unassigned | ||
3.3 |
Fix Released
|
High
|
Unassigned |
Bug Description
Evergreen version: 3.3+
Postgres version: 9.6
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, I suggest we move to his original.
Branch coming soon.
Changed in evergreen: | |
assignee: | nobody → Jason Stephenson (jstephenson) |
Changed in evergreen: | |
milestone: | 3.3.6 → 3.5-alpha |
status: | New → Confirmed |
Changed in evergreen: | |
milestone: | 3.5-alpha → 3.4.2 |
assignee: | nobody → Galen Charlton (gmc) |
no longer affects: | evergreen/3.4 |
Changed in evergreen: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Branch available here:
https:/ /git.evergreen- ils.org/ ?p=working/ Evergreen. git;a=shortlog; h=refs/ heads/user/ miker/lp- 1855329- hold_shelf_ speed