Archives
Contributors
Re: Reducing the size of a database
> 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
by "Graeme Gellatly" <graeme@moahub.nz> - 09:25 - 23 Jan 2024
Reference
-
Reducing the size of a database
Dear contributors,
Some of our customers have been using their database for more than 6 years. They want to reduce the size of the database, by archiving/aggregating old data (accounting entries, sales lines, stock movements, etc.). It would also be easier to do exports, pivot tables and so on.
I see different solutions :
1. Manually aggregate old data, with a specific method by type of tables (account move lines, stock picking, sale order lines). For instance, aggregate old accounting entries with annual miscellaneous operations. Of course, we should keep a backup of the old data somewhere.
2. Mass delete all the old and unused records, such as canceled POs, articles created by mistake. I don't see a way to do this quickly.
Maybe an alternative solution would be a module that sets a "limit date" that acts as an automatic filter when doing exports, pivots, etc.
Do you know any tool or procedure that would help with this ?
Best regards,
-- Victor Champonnois - Coop IT Easy Tel : +32 475 81 01 12
by Victor - 03:21 - 23 Jan 2024