PDA

View Full Version : hands loading slow after purge



pkrjunkie
02-17-2010, 03:55 PM
Hi all:
I just purged 3mm hands.
Followed the instructions in other threads.
I kept my hands and just removed other HH.
After the purge all stats look right and new sessions are going in properly.
I have vacuum/analyse + reindex and defragment after stopping PostgreSQL service.
Have done this multiple times.
So now my hands load really slow. When I say slow i mean SLOOWWWW.
They are all there. It is just like the software is having a hard time finding them.
Sessions load quick its is only the hands ... even just last 100.
So any thoughts on what I can do to get them load normal times again?
Thanks.....

morny
02-17-2010, 04:54 PM
Please see this thread for suggestions on how to improve performance http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html

Also are you using 8.3 or 8.4 postgreSQL and what firewall antivirus are you using.

pkrjunkie
02-17-2010, 11:22 PM
Thanks for the response.
It isn't a performance issue it only happened after the purge.

Using a raptor soley for poker and Hem
Using 8.4 postgreSQL
AVG for anti
12 gig ram
I7
any thoughts?
The only thing i haven't done is Dump/restore

again thanks in advance


Please see this thread for suggestions on how to improve performance http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html

Also are you using 8.3 or 8.4 postgreSQL and what firewall antivirus are you using.



Please see this thread for suggestions on how to improve performance http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html

Also are you using 8.3 or 8.4 postgreSQL and what firewall antivirus are you using.

netsrak
02-18-2010, 08:28 AM
I think its just an autovaccum postgresql demon running in the background.
This should go back to normal work after some hours/days and a reboot.