Odoo Help


This community 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.


the database grows abnormally ?

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

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





| 7 7 8
Turnhout, Belgium

My Odoo blog: http://www.odoo.yenthevg.com/

My Twitter: https://twitter.com/Yenthe666

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;


Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


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