Database Autovacuum Tuning

database_autovacuum_tuning · OCA/server-tools

    Repository
    OCA/server-tools · module folder · Try on Runboat
    Module version
    1.0.1
    Category
    Tools
    Folder size
    0.05 MB
    License
    LGPL-3
    Application
    No
    Auto-installable
    No
    Website
    https://github.com/OCA/server-tools
    Last tracking update
    2026-08-07 08:42:58
    Authors
    Camptocamp, Odoo Community Association (OCA)
    Maintainers
    Camptocamp, Odoo Community Association (OCA)
    Committers
    Weblate, OCA-git-bot, oca-ci, santostelmo
    Odoo dependencies
    odoo/odoo:
    - base_setup
    - base
    - web
    Python dependencies
    None
    System dependencies
    None
    Required by
    None
    Description
    Database Autovacuum Tuning helps administrators keep PostgreSQL healthy by
exposing recommended autovacuum settings in Odoo. It provides guidance and
documentation for sizing thresholds and scale factors so large, busy databases
avoid table bloat and excessive vacuum lag. Use it to standardize autovacuum
configuration across environments and speed up maintenance operations without
manual tuning.

This module is mostly useful for PostgreSQL <= 17. PostgreSQL 18.0 introduces
the `autovacuum_vacuum_max_threshold` parameter, which already provides the
capability this module targets.

The `pgstattuple` extension must be installed on the database.

    Code Analysis ⓘ

    Views touched (3)
    XML IDNameModelTypeStatus
    database_autovacuum_tuning_view_tree database.autovacuum.tuning list New
    databaseautovacuum_tuning_view_search database.autovacuum.tuning search New
    res_config_settings_view_form Database Autovacuum Tuning Settings res.config.settings form Inherits base_setup.res_config_settings_view_form
    HTTP endpoints (0)

    No HTTP endpoints found for this module.

    Models touched (2)

    New fields (3)
    • analyze_threshold Integer
    • name Char
      help='Table name' required=True
    • vacuum_threshold Integer
    Public methods (0)

    No public methods.

    New fields (2)
    • autovacuum_vacuum_analyze_max_threshold Integer
      config_parameter='database_autovacuum_tuning.autovacuum_vacuum_analyze_max_threshold'
    • autovacuum_vacuum_max_threshold Integer
      config_parameter='database_autovacuum_tuning.autovacuum_vacuum_max_threshold'
    Public methods (0)

    No public methods.