Jira (PDB-3356) Use anti-join when eliminating inactive nodes from queries

[Russell Mull (JIRA)]

Title: Message Title

Russell Mull created an issue   PuppetDB / PDB-3356 Use anti-join when eliminating inactive nodes from queries Issue Type: Improvement Assignee: Unassigned Created: 2017/03/14 3:44 PM Priority: Normal Reporter: Russell Mull We currently use a join against the certnames table with inactive nodes filtered out in order to remove inactive nodes from most queries. Because there are usually very few inactive nodes, it should nearly always be faster to do an antijoin against the inactive nodes instead. This is needed for the package inventory work because it takes one of the queries from being very, very slow to being pretty darn fast. Add Comment   This message was sent by Atlassian JIRA (v6.4.14#64029-sha1:ae256fe) -- 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 post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.