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

Partitioned reports table can result in slower PDB queries

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • PDB 6.10.0
    • PDB 6.11.3
    • PuppetDB
    • None
    • HA
    • Needs Assessment
    • Reviewed
    • 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

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

            Dates

              Created:
              Updated:
              Resolved:

              Zendesk Support