Jira (PDB-3745) Various tables in the puppetdb database get autovacuumed too frequently

[Nick Walker (JIRA)]

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

This message was sent by Atlassian JIRA (v7.0.2#70111-sha1:88534db)

[Nick Walker (JIRA)]

Nick Walker updated an issue

PuppetDB / PDB-3745 Various tables in the puppetdb database get autovacuumed too frequently

Change By: Nick Walker h1.  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.

h1.  Pull Request  coming soon  https://github.com/puppetlabs/puppetdb/pull/2393

Add Comment

[Nick Walker (JIRA)]

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)

[Rob Browning (JIRA)]

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

[Nick Walker (JIRA)]

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

[Jarret Lavallee (JIRA)]

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

[Adam Bottchen (JIRA)]

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

[Adam Bottchen (JIRA)]

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

[Austin Blatt (JIRA)]

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

[Heston Hoffman (JIRA)]

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