Contributors mailing list archives

contributors@odoo-community.org

Avatar

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

by
Sicurpharma Srl, Francesco Foresti
- 25/01/2023 09:50:06
Thank you all for your valuable responses, I'll let you know what we find out. 

Cheers!

Il giorno mer 25 gen 2023 alle ore 08:07 Martin Trigaux (Odoo) <notifications@odoo-community.org> ha scritto:
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 odoo.com).
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.

Best,

Martin

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



--

Francesco Foresti
Sicurpharma Srl
+39 333 8123 790

Reference