Uploaded image for project: 'PuppetDB'
  1. PuppetDB
  2. PDB-3356

Use anti-join when eliminating inactive nodes from queries

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: PDB 4.4.0
    • Component/s: None
    • Labels:
      None
    • Template:
    • Team:
      Systems Engineering
    • Story Points:
      2
    • Sprint:
      PuppetDB 2017-03-22
    • QA Risk Assessment:
      Needs Assessment

      Description

      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.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            russell.mull Russell Mull
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Zendesk Support