After deleting 5m hands..

[a-line]

Hi,i was deleting about 5m hands over my database and after that i run
VACUUM FULL postgreQSL.Now my pc is running real slow and HUD too.
When im trying to import some datamined hands HEM imports 2.7h/s and before
that it was something like 40h/s,,,if some 1 can give me some advice how to solve those probs i really appreciate that,thanks..

[fozzy71]

Start > Programs > PostgreSQL 8.x > Stop Service

Install and run http://www.defraggler.com/

Start > Programs > PostgreSQL 8.x > Start Service


Defragging is one of the things listed in this FAQ - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=162

[a-line]

thanks 4 your help,i have Diskeeper 2009 on my pc,i guess that runs the same things or what?

[fozzy71]

Yep, that should be fine, just make sure you stop the postgresql service before defragging and then restart it or reboot afterwards. After defragging, you can also try running this postgresql tuning wizard to fine tune the DB to your machine specs. Choose the 'Dedicated' option for best SQL performance. http://www.holdemmanager.net/faq/afmmain.aspx?faqid=172

[a-line]

Ok,thanks alot..need 2 try that one

[a-line]

1 thing more if u can help,my HEM still shows same amount of players that before i delete those hands,is that normal or what?

[fozzy71]

Yes. I just did this exact same process for the first time, and actually messed up real bad. I had HEM filtered to my stars ID when I purged instead of my alias. :eek: It purged 50k mined hands and 100k of my played FTP hands. :( I had to import a new DB, purge them again, using my alias as the hands to not purge, and delete my first DB that I purged wrong. I then exported from my 2nd, properly purged DB, and created a third DB. I imported the properly purged files to my latest DB and went from 285k hands w/ 60k players, to 235k hands and 45k players. I then was able to delete my 2nd DB, and finally vacuum and defrag.


The only way to get rid of them is to do a DB Export to text files from your current DB. It will export the same amount of files as it did before the purge, but all the hands you purged will be blank/deleted from the files.

Save/Backup the exported HHs. Create a new DB in HEM and import those exported hands. Now delete the DN you purged, vacuum your new DB, and defrag.

[a-line]

Well,i guess i need to do some work :),,thanks!