# 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
- Usage
- Known issues / Roadmap
- Bug Tracker
- Credits
  - Authors
  - Contributors
  - Maintainers

# Configuration

To configure this module, you need to:

1. Go to Settings/Technical/Automation/Scheduled Actions
2. Select actions Vacuum Postgresql Tables and Analyze Postgresql Tables
3. 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
4. Adapt the parameters to match your setting, but the defaults should be fine for most users
5. 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:

1. Go to Settings/Technical/Automation/Scheduled Actions
2. Select action Vacuum Postgresql Tables
3. 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.