Postgres vacuum
Vacuum or analyze Odoo's database tables
Postgres vacuum
This module adds a cronjob that vacuums or analyses postgres tables.
As postgres' autovacuum is not recommended for busy databases, it can be a better choice to schedule this process manually.
Important
This is an alpha version, the data model and design can change at any time without warning. Only for development or testing purpose, do not use in production. More details on development status
Table of contents
Configuration
To configure this module, you need to:
- Go to Settings/Technical/Automation/Scheduled Actions
- Select actions Vacuum Postgresql Tables and Analyze Postgresql Tables
- Adapt the schedule to run at a time when your Odoo installation is least busy, take care that the analyze and vacuum cronjobs won't run simultaneously
- Adapt the parameters to match your setting, but the defaults should be fine for most users
- Note that the vacuum cronjob is inactive by default, because this is a potentially very heavy operation
Usage
To use this module, you need to:
- Go to Settings/Technical/Automation/Scheduled Actions
- Select action Vacuum Postgresql Tables
- Click the Run Manually button
Known issues / Roadmap
- it would be nice if the cronjob could detect some odoo-specific measure of "busyness" and only run if it is below some threshold
- add some statistics in the model views about number of dead rows, last vacuum timestamp etc from https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STAT-ALL-TABLES-VIEW
Bug Tracker
Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us to smash it by providing a detailed and welcomed feedback.
Do not contact contributors directly about support or help with technical issues.
Credits
Authors
- Hunki Enterprises BV
- Therp BV
Contributors
- Kevin Kamaa <kkahumba@therp.nl> (https://therp.nl)
- Holger Brunn <mail@hunki-enterprises.com> (https://hunki-enterprises.com)
Maintainers
This module is maintained by the OCA.
OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.
This module is part of the OCA/server-tools project on GitHub.
You are welcome to contribute. To learn how please visit https://odoo-community.org/page/Contribute.
Once the user has seen at least one product this snippet will be visible.