Database Autovacuum Tuning

database_autovacuum_tuning
REPOSITORY
REPOSITORYOCA/server-tools
GIT
GIThttps://github.com/OCA/server-tools.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/server-tools/tree/18.0/database_autovacuum_tuning
VERSION
VERSION 1.0.1
CATEGORY
CATEGORYTools
LICENSE
LICENSELGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), Camptocamp
MAINTAINERS
MAINTAINERSOdoo Community Association (OCA), Camptocamp
COMMITTERS
COMMITTERSWeblate, OCA-git-bot, oca-ci, santostelmo
WEBSITE
WEBSITEhttps://github.com/OCA/server-tools
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 19:30:08
ODOO DEPENDENCIES
ODOO DEPENDENCIES odoo/odoo:
    - base_setup
    - base
    - web
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
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 block Inherits base_setup.res_config_settings_view_form
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.