Skip to Content
  2. Mailing Lists
  3. Contributors
  4. Re: Size of ir.translation table over total db size

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

Good idea but vacuum full only in off peak times and after a proper backup (for the own safety) ;-)

Best Frederik

Am 24.01.23 um 20:51 schrieb Moises Lopez:
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 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

--
Moisés López Calderón
Mobile: (+521) 477-752-22-30
Twitter: @moylop260
hangout: moylop260@vauxoo.com
http://www.vauxoo.com - Odoo Gold Partner
Twitter: @vauxoo

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

-- 
Dr.-Ing. Frederik Kramer
Geschäftsführer

initOS GmbH
Innungsstraße 7
21244 Buchholz i.d.N.

Phone:  +49 4181 13503-12
Fax:    +49 4181 13503-10
Mobil:  +49 179 3901819

Email: frederik.kramer@initos.com
Web:   www.initos.com

Geschäftsführung:
Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke

Sitz der Gesellschaft: Buchholz i.d.N.
Amtsgericht Tostedt, HRB 205226
Steuer-Nr: 15/200/53247
USt-IdNr.: DE815580155
by Frederik Kramer - 09:06 - 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 Foresti
    Sicurpharma Srl
    by Francesco Foresti - 07:11 - 24 Jan 2023