I just noticed that the account_move_line table was about 200MB while the index for that table was over 1GB.
This question has been flagged
1
Reply
8650
Views
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.
The VACUUM command will also reclaim space by doing garbage collection within the table itself and rebuild indexes.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
3
Mar 15
|
9039 | ||
|
1
Apr 26
|
10293 | ||
|
2
Mar 15
|
12926 | ||
|
1
Dec 22
|
28196 | ||
|
0
Mar 15
|
5635 |
