PDA

View Full Version : ways to accelerate / set up HM + sql



BubbleBoy
08-13-2009, 05:32 PM
Hi guys, some more general question.

Main problem is my database is really slow, and my PC with it. I play Ongame so things are really bad sometimes. I did all the analyze/vacuum stuff with pgadmin, I defragmented my HD but no success.

I'm looking either for some smart idea to speed it up, or to redo my setup.

If I redo everything, what would be a smart setup?

(I run a 2.6ghz dual core with 2GB ram, winXP and a 7200rpm hd)

fozzy71
08-13-2009, 06:07 PM
Purged, vacuumed, reindexed and HEM runs much worse (http://www.holdemmanager.net/forum/showthread.php?p=69196)



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


Awesome fozzy, ty. HEM is running better than ever!

BubbleBoy
08-13-2009, 07:10 PM
thanks thats a sick thread