İçereği Atla
Menü
Bu soru işaretlendi
1 Cevapla
6748 Görünümler

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

Avatar
Vazgeç
Üretici En İyi Yanıt

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
Vazgeç

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

İlgili Gönderiler Cevaplar Görünümler Aktivite
3
Mar 15
6985
1
Mar 15
7997
2
Mar 15
10724
1
Ara 22
25999
0
Mar 15
3888