Jira (PDB-4640) Add a file index to catalog_resources for CD4PE Impact Analysis
Title: Message Title Heston Hoffman updated an issue PuppetDB / PDB-4640 Add a file index to catalog_resources for CD4PE Impact Analysis Change By: Heston Hoffman Labels: resolved-issue-added Add Comment This message was sent by Atlassian JIRA (v7.7.1#77002-sha1:e75ca93) -- 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.344131.1580319012000.29044.1582052760297%40Atlassian.JIRA.
Jira (PDB-4640) Add a file index to catalog_resources for CD4PE Impact Analysis
Title: Message Title Austin Blatt updated an issue PuppetDB / PDB-4640 Add a file index to catalog_resources for CD4PE Impact Analysis Change By: Austin Blatt Release Notes Summary: If you have the PostgreSQL extension pg_trgm configured, adds an index on the catalog_resources table's file column.In a separate release notes entry, we have deprecated running PostgreSQL without the pg_trgm extension Add Comment This message was sent by Atlassian JIRA (v7.7.1#77002-sha1:e75ca93) -- 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.344131.1580319012000.26413.1581702480235%40Atlassian.JIRA.
Jira (PDB-4640) Add a file index to catalog_resources for CD4PE Impact Analysis
Title: Message Title Austin Blatt updated an issue PuppetDB / PDB-4640 Add a file index to catalog_resources for CD4PE Impact Analysis Change By: Austin Blatt Release Notes: Not Needed New Feature Add Comment This message was sent by Atlassian JIRA (v7.7.1#77002-sha1:e75ca93) -- 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.344131.1580319012000.26408.1581702360267%40Atlassian.JIRA.
Jira (PDB-4640) Add a file index to catalog_resources for CD4PE Impact Analysis
Title: Message Title Austin Blatt assigned an issue to Austin Blatt PuppetDB / PDB-4640 Add a file index to catalog_resources for CD4PE Impact Analysis Change By: Austin Blatt Assignee: Austin Blatt Add Comment This message was sent by Atlassian JIRA (v7.7.1#77002-sha1:e75ca93) -- 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.344131.1580319012000.26372.1581701700293%40Atlassian.JIRA.
Jira (PDB-4640) Add a file index to catalog_resources for CD4PE Impact Analysis
Title: Message Title Austin Blatt updated an issue PuppetDB / PDB-4640 Add a file index to catalog_resources for CD4PE Impact Analysis Change By: Austin Blatt Team: HA Add Comment This message was sent by Atlassian JIRA (v7.7.1#77002-sha1:e75ca93) -- 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.344131.1580319012000.6846.1580411460227%40Atlassian.JIRA.
Jira (PDB-4640) Add a file index to catalog_resources for CD4PE Impact Analysis
Title: Message Title Nick Walker commented on PDB-4640 Re: Add a file index to catalog_resources for CD4PE Impact Analysis oh cool well if we have test data and infracore I'd think we should consider additional optimizations in addition to the index Add Comment This message was sent by Atlassian JIRA (v7.7.1#77002-sha1:e75ca93) -- 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.344131.1580319012000.5818.1580338980279%40Atlassian.JIRA.
Jira (PDB-4640) Add a file index to catalog_resources for CD4PE Impact Analysis
Title: Message Title Austin Blatt updated an issue PuppetDB / PDB-4640 Add a file index to catalog_resources for CD4PE Impact Analysis Change By: Austin Blatt Team: HA Add Comment This message was sent by Atlassian JIRA (v7.7.1#77002-sha1:e75ca93) -- 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.344131.1580319012000.5265.1580325720440%40Atlassian.JIRA.
Jira (PDB-4640) Add a file index to catalog_resources for CD4PE Impact Analysis
Title: Message Title Austin Blatt commented on PDB-4640 Re: Add a file index to catalog_resources for CD4PE Impact Analysis Adam Bottchen any way we can get the database dump you mentioned so we can test its performance? Add Comment This message was sent by Atlassian JIRA (v7.7.1#77002-sha1:e75ca93) -- 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.344131.1580319012000.5122.1580323980403%40Atlassian.JIRA.
Jira (PDB-4640) Add a file index to catalog_resources for CD4PE Impact Analysis
Title: Message Title Adam Bottchen created an issue PuppetDB / PDB-4640 Add a file index to catalog_resources for CD4PE Impact Analysis Issue Type: Improvement Assignee: Unassigned Created: 2020/01/29 9:30 AM Priority: Major Reporter: Adam Bottchen As seen in CDPE-2850, CD4PE's impact analysis puts a great deal of stress on the catalog_resources table doing selects against the file row. We have seen in customer cases that performance can be greatly improved if an index is added and autovacuum frequency is increased: CREATE INDEX catalog_resources_file_idx on catalog_resources USING gin (file gin_trgm_ops) WHERE file IS NOT NULL; ALTER TABLE catalog_resources SET (autovacuum_analyze_scale_factor = 0.01); ALTER INDEX catalog_resources_file_idx SET (fastupdate=false); I do not see much downside to these changes being the default.
