Database Autovacuum Tuning
database_autovacuum_tuning · OCA/server-tools
-
Security22/251 minor finding
-
Activity20/25Last human commit 9 months ago
-
Required by5/250 modules depend on it
-
Maturity5/25In 1 Odoo series since 18.0
Heuristic over the facts below, not an audit · How it's computed
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.
Dependencies
- Odoo dependencies
- Python dependencies
- None
- System dependencies
- None
- Required by
- None
Code analysis
Extracted from the source by best-effort static analysis (no code is executed); details may be incomplete.
Views touched 3
| XML ID | Name | Model | Type | Status |
|---|---|---|---|---|
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
-
analyze_thresholdInteger -
nameCharhelp='Table name'required=True -
vacuum_thresholdInteger
No public methods.
-
autovacuum_vacuum_analyze_max_thresholdIntegerconfig_parameter='database_autovacuum_tuning.autovacuum_vacuum_analyze_max_threshold' -
autovacuum_vacuum_max_thresholdIntegerconfig_parameter='database_autovacuum_tuning.autovacuum_vacuum_max_threshold'
No public methods.