Jira (PDB-4673) Provide a PQL operator that uses LIKE rather than a regex match

[Adam Bottchen (Jira)]

Adam Bottchen created an issue

PuppetDB / PDB-4673 Provide a PQL operator that uses LIKE rather than a regex match Issue Type: Improvement Assignee: Unassigned Created: 2020/03/04 6:17 PM Priority: Normal Reporter: Adam Bottchen Problem Right now, PQL only provides access to the regex pattern match operator. As seen in multiple customer cases, and highlighted in CDPE-2927, this operator can lead to significantly slower queries to postgres when compared to the LIKE operator. In an example dataset from a customer system, a query using the regex operator took 7 minutes to complete, but only 2.5 seconds when replaced with LIKE, as the query planner was able to prioritize the correct index. Recommendation Provide a PQL operator that translates into LIKE when building the resulting SQL to provide users the choice. Add Comment

This message was sent by Atlassian Jira (v8.5.2#805002-sha1:a66f935)

[Austin Boyd (Jira)]

Austin Boyd updated an issue

PuppetDB / PDB-4673 Provide a PQL operator that uses LIKE rather than a regex match

Change By: Austin Boyd Zendesk Ticket Count: 1 Zendesk Ticket IDs: 38273

Add Comment

[Austin Boyd (Jira)]

Austin Boyd updated an issue

PuppetDB / PDB-4673 Provide a PQL operator that uses LIKE rather than a regex match

Change By: Austin Boyd Labels: jira_escalated

Add Comment

[Adam Bottchen (Jira)]

Adam Bottchen commented on PDB-4673

Re: Provide a PQL operator that uses LIKE rather than a regex match Nick Walker. That sounds great. I opened CDPE-3042 to generalize the question rather than try to go directly to possible solutions.

Add Comment