Skip to Content
Menu
This question has been flagged
1 Atsakyti
7235 Rodiniai

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

Portretas
Atmesti
Autorius Best Answer

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.

Portretas
Atmesti

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

Related Posts Replies Rodiniai Veikla
3
kov. 15
7419
1
kov. 15
8520
2
kov. 15
11205
1
gruod. 22
26429
0
kov. 15
4304