Jira (PDB-5377) Try fact-contents improvements on fact-path gc

[Rob Browning (Jira)]

Title: Message Title

Rob Browning commented on PDB-5377   Re: Try fact-contents improvements on fact-path gc The gc query was already similar, though not the same as the newer fact-contents query, and testing the existing gc query on a fast machine against a version of the fact-contents query that had been adjusted to only track the relevant data showed that the existing gc query was already roughly twice as fast. Though for context, that was on a very fast nvme drive, and while it was running against 100k nodes, they were benchmark generated, and not rewritten, so that table was presumably very compact, etc. Since we've seen that gc query taking 20+ minutes at client sites with fewer nodes, we'd recommend working with CS to gather some relevant information from a collection of notable sites as a next step – both data for which we'd provide the collection tools, and the coincident support script (i.e. sar) data. Add Comment   This message was sent by Atlassian Jira (v8.20.2#820002-sha1:829506d) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.423963.1637167928000.3441.1642617540284%40Atlassian.JIRA.