Hi people,
Wanted to check with you regarding the performance of HM2 inbuilt purge process. And I hope it's me missing something very basic and not poor expertise of HM2 developers.
Setup:
- HM2: latest version under admin account
- DB size: ~40 GB
- OS: Windows 10 Pro
- CPU: Ryzen7 with 16 logical cores - all available for HM2
- RAM: 16 GB - ~10GB available
- HDD: 2xSSD in RAID0 with write speed > 800 MB/s - ~100GB available
- NoteCaddy is OFF
- Postgre 8.4 (the one installed along with HM2) is setup locally with settings by default. If i put performance setting described in http://forums.holdemmanager.com/gene...ance-tips.html, Postgre is crashing on this DB.
- The DB was vacuumed and optimized both by using HM2 functionality and pgAdmin (which compacts DB much better)
Issue:
I'm trying to purge a good chunk (~70%) of this DB and after 8hrs it passed some 30-40% only. The CPU consumption less than 20% on all the core, the HDD consumption is close to 0 (few MB/s). RAM consumption is ~400 MB.
As an old DB developer, I expect moderate CPU consumption and very high HDD usage due to massive SQL delete operation + removal of the local files. It does not happen, HW consumption is close to 0, the HM2 is not hanging though, the process is going on but very slow.
As a work-around I could have created a new DB and imported what I need only. However, in this case, I would lose all the notes and tags attached to the opponents. Also, I would like to avoid messing up with the DB by transferring the tables containing the notes, even though it should not be a rocket science. Therefore, I prefer using inbuilt functionality if possible.
Any suggestions?