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

Investigate rampant (often tiny) temp file creation

    Details

    • Type: Task
    • Status: Accepted
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Template:
    • Team:
      PuppetDB
    • QA Risk Assessment:
      Needs Assessment

      Description

      It looks like this may be jsonb operator related, but not sure.  We've observed it in at least two contexts, the (old) fact-path-gc query, and migration 66.  In the former case, using a temp table side-stepped the issue, and in the latter a 2GB+ work-mem did.  Let's poke around and see if we can figure out what's going on.

      In the migration case, this query may have been the culprit (was notable in the pg stat activity):

        update factsets fs
        set stable = (select json_object_agg(name, value)
        ...
      

      Gabe Schuyler has observed the migration problem.
       

        Attachments

          Issue Links

            Activity

              jsd-sla-details-panel

                People

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

                  Dates

                  • Created:
                    Updated: