Jira (PDB-5218) Investigate query performance for "ESTATE - nodes with specific operating system"

[Bogdan Irimie (Jira)]

Title: Message Title

Bogdan Irimie created an issue   PuppetDB / PDB-5218 Investigate query performance for "ESTATE - nodes with specific operating system" Issue Type: Task Assignee: Unassigned Created: 2021/07/29 6:38 AM Priority: Normal Reporter: Bogdan Irimie From the performance test we ran in https://docs.google.com/spreadsheets/d/1eaOZhSoTyZ3k_0905_3BSDZpViz3WbTTJGQzGdoTsnI/edit?usp=sharing curl --location -g --request GET 'http://localhost:8080/pdb/query/v4/nodes?query=["extract", [["function", "count"]], ["and",["~", ["fact", "operatingsystem"], "Cent.*"]]]' is an outlier and we should investigate if this query can be rewritten in a more efficient way or if we can make changes to the query engine in order to improve it's performance Add Comment   This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.409151.1627565932000.93891.1627565940057%40Atlassian.JIRA.