[PDB-4198] Investigate rampant (often tiny) temp file creation Created: 2018/11/28  Updated: 2019/08/13

Status: Accepted
Project: PuppetDB
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Normal
Reporter: Rob Browning Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
relates to PDB-3924 Avoid temp file flood during fact pat... Closed
Team: PuppetDB
QA Risk Assessment: Needs Assessment


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.

Generated at Sat Aug 08 09:01:12 PDT 2020 using Jira 8.5.2#805002-sha1:a66f9354b9e12ac788984e5d84669c903a370049.