Jira (PDB-3745) Various tables in the puppetdb database get autovacuumed too frequently
Title: Message Title Heston Hoffman updated an issue PuppetDB / PDB-3745 Various tables in the puppetdb database get autovacuumed too frequently Change By: Heston Hoffman Labels: cstop10 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.220383.1509729176000.59974.1565994600430%40Atlassian.JIRA.
Jira (PDB-3745) Various tables in the puppetdb database get autovacuumed too frequently
Title: Message Title Austin Blatt updated an issue PuppetDB / PDB-3745 Various tables in the puppetdb database get autovacuumed too frequently Change By: Austin Blatt Fix Version/s: PDB 6.5.0 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.220383.1509729176000.56594.1565814600772%40Atlassian.JIRA.
Jira (PDB-3745) Various tables in the puppetdb database get autovacuumed too frequently
Title: Message Title Adam Bottchen updated an issue PuppetDB / PDB-3745 Various tables in the puppetdb database get autovacuumed too frequently Change By: Adam Bottchen CS Priority: Reviewed Major 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 post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-3745) Various tables in the puppetdb database get autovacuumed too frequently
Title: Message Title Adam Bottchen updated an issue PuppetDB / PDB-3745 Various tables in the puppetdb database get autovacuumed too frequently Change By: Adam Bottchen Labels: cstop10 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 post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-3745) Various tables in the puppetdb database get autovacuumed too frequently
Title: Message Title Jarret Lavallee updated an issue PuppetDB / PDB-3745 Various tables in the puppetdb database get autovacuumed too frequently Change By: Jarret Lavallee CS Priority: Needs Priority Reviewed 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 post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-3745) Various tables in the puppetdb database get autovacuumed too frequently
Title: Message Title Nick Walker updated an issue PuppetDB / PDB-3745 Various tables in the puppetdb database get autovacuumed too frequently Change By: Nick Walker CS Priority: Needs Priority 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 post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-3745) Various tables in the puppetdb database get autovacuumed too frequently
Title: Message Title Rob Browning updated an issue PuppetDB / PDB-3745 Various tables in the puppetdb database get autovacuumed too frequently Change By: Rob Browning Sprint: PDB Triage 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 post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-3745) Various tables in the puppetdb database get autovacuumed too frequently
Title: Message Title Nick Walker updated an issue PuppetDB / PDB-3745 Various tables in the puppetdb database get autovacuumed too frequently Change By: Nick Walker Sprint: PDB Triage 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 post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-3745) Various tables in the puppetdb database get autovacuumed too frequently
Title: Message Title Nick Walker updated an issue PuppetDB / PDB-3745 Various tables in the puppetdb database get autovacuumed too frequently Change By: Nick Walker h1. The ProblemObserving customer environments and our internal puppet deployment using pgbadger we see that various table gets VACUUMed far more frequently than necessary only removing a few hundred or thousand dead tuples per vacuum.This can be improved by changing the percentage threshold after which postgresql thinks it should vacumm the tables. To start with the factsets, catalogs, and certnames tables have the largest issue. h1. Pull Request coming soon https://github.com/puppetlabs/puppetdb/pull/2393 Add Comment This message was sent by Atlassian JIRA (v7.0.2#70111-sha1:88534db) -- 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 post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-3745) Various tables in the puppetdb database get autovacuumed too frequently
Title: Message Title Nick Walker created an issue PuppetDB / PDB-3745 Various tables in the puppetdb database get autovacuumed too frequently Issue Type: Bug Assignee: Unassigned Created: 2017/11/03 10:12 AM Priority: Normal Reporter: Nick Walker The Problem Observing customer environments and our internal puppet deployment using pgbadger we see that various table gets VACUUMed far more frequently than necessary only removing a few hundred or thousand dead tuples per vacuum. This can be improved by changing the percentage threshold after which postgresql thinks it should vacumm the tables. To start with the factsets, catalogs, and certnames tables have the largest issue. Pull Request coming soon Add Comment
