Archives
Contributors
Re: Size of ir.translation table over total db size
Re: Size of ir.translation table over total db size
Re: Size of ir.translation table over total db size
Hi,
There is an issue related with vacuum claim space in tables
Also, you didn't mention the PG version used
But try running a "vacuum full"
On Tue 24 Jan 2023 at 12:11 p.m. Francesco Foresti <notifications@odoo-community.org> wrote:
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 ForestiSicurpharma Srl_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
Moisés López Calderón
Mobile: (+521) 477-752-22-30
Twitter: @moylop260
Twitter: @vauxoo
by Moisés López Calderón - 08:50 - 24 Jan 2023
Reference
-
Size of ir.translation table over total db size
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 ForestiSicurpharma Srl
by Francesco Foresti - 07:11 - 24 Jan 2023