[PDB-3838] Simple equality queries to the facts endpoint generates jsonb_each Created: 2018/02/07 Updated: 2018/08/24 Resolved: 2018/03/09 |
|
Status: | Closed |
Project: | PuppetDB |
Component/s: | None |
Affects Version/s: | None |
Fix Version/s: | PDB 5.2.1 |
Type: | Bug | Priority: | Normal |
Reporter: | Erik Hansen | Assignee: | Russell Mull |
Resolution: | Fixed | Votes: | 0 |
Labels: | None | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified |
Attachments: |
![]() |
Template: | customfield_10700 235623 |
Team: | Data Platform |
Story Points: | 3 |
Sprint: | Data Platform 2018-03-14 |
Method Found: | Customer Feedback |
Release Notes: | Bug Fix |
Release Notes Summary: | Significantly improve performance of facts queries which constrain 'name' to a single value (for example: "facts [value, count()] { name = 'osFamily' group by value }" |
Description |
This happens for simple equality:
does this. someone tried to work around the problem like this:
But that was still slow. The resulting query plan: (attached in facts_entitiy_jsonb_each.sql) |
Comments |
Comment by Jeff Yarnell [ 2018/02/14 ] |
Erik Hansen We have bumped this issue out of our sprint ending Feb 28 with the intent of revisiting it in early March. Any concerns? |
Comment by Jeff Yarnell [ 2018/03/14 ] |
Russell Mull Release notes? |