So my db is huge because I have loaded millions of millions observed hands in there. So I purged almost all observed hands (about 18 million). I did a vaccuum analyze and then a reindex.
The problem is my db is still huge (60gb!). I really deleted every hand except the ones I played (around 600K). The vaccuum analyze ran for about 2 days
So now I wonder what I can do except start a new db. The main problem I have is that when I try to do hh review it won't load the hands up anymore (it looks like it takes forever but then it won't show them ever and just stop working). So I can still see how many hands I played, all my stats, etc. but I can' access the hands easily (it will still show then if I only pick like 1 specific day and it's like 1K hands or so).
Does doing another vaccuum analyze help? Is there any other way to decrease the size and make HEM faster (I read the top 10 performancet tips).
One more thing. When I choose like last 20 days or so the in the reports tab the part where the hands should be it's just white and it does not even try to load any hands. However when I start HEM new and say like 1 day then it will load the hands after a while. Very weird.