Uploaded image for project: 'PuppetDB'
  1. PuppetDB
  2. PDB-3745

Various tables in the puppetdb database get autovacuumed too frequently

    Details

    • Template:
    • Method Found:
      Customer Feedback
    • CS Priority:
      Major
    • Release Notes:
      Enhancement
    • Release Notes Summary:
      Default auto-vacuum settings for several tables have been updated to match support's recommendations. These changes will apply (once) at the next upgrade.
    • QA Risk Assessment:
      Needs Assessment

      Description

      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

      https://github.com/puppetlabs/puppetdb/pull/2393

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              nick.walker Nick Walker
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Zendesk Support