1. Mailing Lists
  2. Contributors
  3. Re: Reducing the size of a database

Contributors mailing list archives

contributors@odoo-community.org

Browse archives

Re: Reducing the size of a database

Avatar

Re: Reducing the size of a database

by "Graeme Gellatly" <graeme@moahub.nz> - 23/01/2024 21:24:04
Mail message table is typically 50 per cent of database or more. Frankly 6 years is not a lot. In my country fiscal authorities require 7 years, some other legal requirements need 50 years.

On Wed, 24 Jan 2024, 5:36 am Holger Brunn, <notifications@odoo-community.org> wrote:
> In my experience a


> huge amount of records can be deleted by deleting old chatter


> records.

similar experience here, and for that we have
https://github.com/OCA/server-tools/tree/14.0/autovacuum_message_attachment
and its migrations to higher versions in the PRs.

You should run the third query from
https://wiki.postgresql.org/wiki/Disk_Usage
anyways to first get an impression where the space goes.



-- 
Your partner for the hard Odoo problems
https://hunki-enterprises.com

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

Reference