Contributors mailing list archives

contributors@odoo-community.org

Avatar

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

by
Sicurpharma Srl, Francesco Foresti
- 24/01/2023 20:23:01
Thank you, sorry you are right, I'm talking of odoo 14

On Tue, Jan 24, 2023, 20:21 Sylvain LE GAL (GRAP) <notifications@odoo-community.org> wrote:

Hi.

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. 

Thanks!

--

Francesco Foresti
Sicurpharma Srl

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

-- 
Sylvain LE GAL
- GRAP, service informatique
- 3 Grande rue des Feuillants 69001 LYON, 09.72.32.33.17
- Astreinte : 06.81.85.61.43 // informatique@grap.coop

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

Reference