Contributors mailing list archives

Browse archives


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

Groupement Régional Alimentaire de Proximité, Sylvain LE GAL
- 24/01/2023 20:07:53


Translation mechanism changed a lot recently. You didn't mentionned the version of the Odoo for your two exemple :

In my company :

- odoo V12 CE (en_US + fr_FR)

- pg_database_size : 51GB

- pg_relation_size of ir.translation : 10MB

- pg_total_relation_size of ir.translation : 32MB (=0,06%)

Le 24/01/2023 à 19:11, Francesco Foresti a écrit :
Hi all, 

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.

We were a bit surprised to find out about the table size and we're looking for feedback on whether these proportions sound "regular" to you. 



Francesco Foresti
Sicurpharma Srl

Post to:

Sylvain LE GAL
- GRAP, service informatique
- 3 Grande rue des Feuillants 69001 LYON,
- Astreinte : //