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

See if we can drop joins that a query doesn't need in some cases

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Normal
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: PDB 6.9.0
    • Component/s: None
    • Template:
    • Team:
      PuppetDB
    • Release Notes:
      New Feature
    • Release Notes Summary:
      Hide
      PuppetDB now has an experimental query optimizer (link to api/query/v4/query#experimental_query_optimization) that may be able to
      substantially decrease the cost (and correspondingly decrease the
      response time) of some queries. (PDB-4512)
      Show
      PuppetDB now has an experimental query optimizer (link to api/query/v4/query#experimental_query_optimization) that may be able to substantially decrease the cost (and correspondingly decrease the response time) of some queries. ( PDB-4512 )
    • QA Risk Assessment:
      Needs Assessment

      Description

      It looks like this may dramatically speed up some queries (and correspondingly decrease the load on pg), but there are plenty of questions.

        Attachments

          Activity

            People

            Assignee:
            rob.browning Rob Browning
            Reporter:
            rob.browning Rob Browning
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Zendesk Support