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

Partitioned reports table can result in slower PDB queries

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: PDB 6.10.0
    • Fix Version/s: PDB 6.11.3
    • Component/s: None
    • Labels:
      None
    • Template:
    • Team:
      HA
    • Method Found:
      Needs Assessment
    • CS Priority:
      Reviewed
    • QA Risk Assessment:
      Needs Assessment

      Description

      Particularly with the PE Console, the newly partitioned reports table can result in slower queries compared to previous versions, possibly because of the removal of this index. For an example, see this explain plan where it has to sequence scan 13 million rows to populate part of the "Status" page.

        Attachments

          Activity

            People

            Assignee:
            rob.browning Rob Browning
            Reporter:
            adrian.parreiras-horta Adrian Parreiras Horta
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Zendesk Support