Ir al contenido
Menú
Se marcó esta pregunta
1 Responder
6726 Vistas

I just noticed that the account_move_line table was about 200MB while the index for that table was over 1GB.

Avatar
Descartar
Autor Mejor respuesta

While I don't know why this is the case - reindexing this specific database reclaimed 2GB of space and reduced a 4.5GB database to 2.5GB. It was a 6.1 database upgraded via Odoo to version 7.0.  

It has about 135,000 records in the account_move_line table.

Avatar
Descartar

The VACUUM command will also reclaim space by doing garbage collection within the table itself and rebuild indexes.

Publicaciones relacionadas Respuestas Vistas Actividad
3
mar 15
6966
1
mar 15
7972
2
mar 15
10707
1
dic 22
25985
0
mar 15
3878