PDA

View Full Version : after purge of 1,000,000 hands, hand details REALLY SLOW



DragonDUG
01-05-2011, 02:54 PM
I have a fairly high count of detail hand histories.
I detail purged over a million hands of misc play (based on limits),
then did a full vacuum with pgadmin.
when i went back to "sessions" the summary was still normal, but the details took minutes to display instead of seconds.
So, i went back to pgadmin and did a reindex.
Same problem. Summary normal, details take minutes instead of seconds....

I have modified pg-conf? previously (sp) and even used tuning portion of HM Data base maintenance.

Any Suggestions??????

I am using 1.11.05d of Holdem + Omaha manager Professional.....

DragonDUG
01-05-2011, 03:17 PM
I played around and DELETED hero name; then readded hero name.

Fixed problem......

netsrak
01-06-2011, 04:30 AM
Thanks for the feedback :)

chaser1
01-25-2011, 06:38 PM
Hello! I have the same problem. I have purged 5 million hands, and now everything is really slow. What should I do? Where should I delete Hero name and then add it? Please help.

Patvs
01-26-2011, 10:48 AM
Read:
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html



Fully vacuum/analyse/reindex database after purging hands in pgadminIII.