Contributors mailing list archives


Re: Size of ir.translation table over total db size

Martin Trigaux
- 25/01/2023 08:01:57
On 24/01/2023 19:11, Francesco Foresti wrote:

we've recently found out that on a "clean" db (not yet in production), with around 350 modules installed and no customer data imported, the ir.translation table occupies about 95% of the space - about 9GB. Just two languages are enabled.

On another db in production since 2+ years, out of 7,5 GB of the db size, ir.translations occupies 21% of the space (1,6GB). Just one language is enabled here.

Your clean db stats seems to the roof. On the Github PR odoo/odoo#45958 I measured the size with 7 languages installed on a new database. I did not have 350 modules installed but the size was measured in MB, not GB.
I suspect one (or more) of the module is polluting the table. Check the entries based on the module field to find the culprit.

On a production database, it may grow a lot but 1.6 Gb still seems excessive (I don't think we reached that size on
On old database, orphan translations (pointing to records that no longer exists) may increase the size of the table unnecessarily but 2 years is not that old either.
I would start by investigating what takes so much space in this table.