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

indexes on transaction_uuid and hash are not used in querying

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: PDB 3.2.2
    • Component/s: None
    • Labels:
      None
    • Template:
    • Story Points:
      2
    • Sprint:
      PuppetDB 2015-12-02

      Description

      We should either flip them back to an indexed varchar 40, or munge hashes to bytea on the RHS of the equality comparison. We should probably just pick whatever approach is fastest, since this directly influences speed of syncing and the storage benefits of bytea are probably insignificant compared to the kind of json storage we've been adopting.

        Attachments

          Activity

            jsd-sla-details-panel

              People

              • Assignee:
                Unassigned
                Reporter:
                wyatt Wyatt Alt
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: