PDA

View Full Version : Purged, vacuumed, reindexed and HEM runs much worse



zook
07-19-2009, 06:34 PM
I did some long overdue hand purging (over a million hands), vacuum/analyzed and reindexed. Now HEM is performing terribly! It takes longer to import and takes forever to update my cash game stats or pull up all my hands for the day. What's going on? I'm using 1.09 beta18a. Thanks.

fozzy71
07-19-2009, 06:58 PM
I would suggest you do the majority of the things in this thread: http://www.holdemmanager.net/forum/showthread.php?t=11194

Some of the most important things, imo:

- Turning off logging and deleting existing logs
- Vacuum/Full/Analyze, then Reindex
- SQL Tuning Wizard - http://www.holdemmanager.net/faq/afmmain.aspx?faqid=172
- Defrag last and make sure you stop the postgresql service before you defrag. I personally use Defraggler.
- Do a Cold Boot (Shut Down > Start) before you use HM again

zook
07-21-2009, 01:14 AM
Awesome fozzy, ty. HEM is running better than ever!

fozzy71
07-21-2009, 07:51 AM
Awesome fozzy, ty. HEM is running better than ever!

Great to hear. TYVM for updating this thread about the success of my suggestions.