Odoo Help


the database grows abnormally ?

on 1/30/15, 1:05 PM 690 views

the database grows abnormally how i must check where is the problem



On 1/30/15, 2:16 PM

Are you using Odoo V7 or V8? I'd assume that your Odoo is saving all its images in your postgreSQL database. Due to all the images being saved in your database your database size grows fast. For more information look at https://www.odoo.com/forum/help-1/question/where-are-document-attachments-stored-529 for example. You'll find out more about this here.

On 2/15/15, 3:08 AM

i apply this requete  for knowing what is the table responsable of this size:

SELECT table_catalog

pg_relation_size(table_schema || '.' || table_name) As Taille_donnees

pg_total_relation_size(table_schema || '.' || table_name) As Taille_totale

FROM information_schema.tables

ORDER BY Taille_totale DESC;


About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 1/30/15, 1:05 PM
Seen: 690 times
Last updated: 3/16/15, 8:10 AM