Evergreen

permission.grp_descendants should be marked stable

  1. Series 3.1
  2. Bug #1768141
Bug #1768141 reported by Galen Charlton
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Evergreen
Fix Released
Low
Unassigned
Evergreen 3.4-rc
3.1
Fix Released
Low
Unassigned
Evergreen 3.1.16
3.2
Fix Released
Low
Unassigned
Evergreen 3.2.10
3.3
Fix Released
Low
Unassigned
Evergreen 3.3.5

Bug Description

The database function permission.grp_descendants should be marked stable; it qualifies, and doing so should allow PostgreSQL to improve query plans. One example of a query that would benefit is searching by patron profile (a la bug 1497322)

Evergreen 3.0+

Galen Charlton (gmc)
summary: - permission.grp_descendants should be marked table
+ permission.grp_descendants should be marked stable
Elaine Hardy (ehardy)
tags: added: performance permissions
Revision history for this message
Chris Sharp (chrissharp123) wrote :

Branch implementing this change is available here:

https://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/csharp/lp1768141_mark_perm_grp_descendants_func_stable

tags: added: pullrequest
Revision history for this message
Galen Charlton (gmc) wrote :

Thanks for the patch, Chris. Signoff branch is working/user/gmcharlt/1768141_signoff; that branch also contains a follow-up to change the DB update to an "ALTER FUNCTION ... STABLE".

Changed in evergreen:
milestone: none → 3.3.3
status: New → Confirmed
Galen Charlton (gmc)
tags: added: signedoff
Evergreen Bug Maintenance (bugmaster)
Changed in evergreen:
milestone: 3.3.3 → 3.3.4
Evergreen Bug Maintenance (bugmaster)
Changed in evergreen:
milestone: 3.3.4 → 3.3.5
Jason Boyer (jboyer)
no longer affects: evergreen/3.4
Changed in evergreen:
milestone: 3.3.5 → 3.4-beta2
assignee: nobody → Jason Boyer (jboyer)
Revision history for this message
Jason Boyer (jboyer) wrote :

Looks good to me, pushed to rel_3_1...master, thanks Chris and Galen!

tags: removed: performance
Changed in evergreen:
assignee: Jason Boyer (jboyer) → nobody
status: Confirmed → Fix Committed
Galen Charlton (gmc)
Changed in evergreen:
milestone: 3.4-beta2 → 3.4-rc
Galen Charlton (gmc)
Changed in evergreen:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.