PDA

View Full Version : Postgre process kills cpu.



J-Oddjob
05-25-2010, 02:07 PM
When I open a new HM-window it takes a LOT of time and cpu-power ( 50% )to show up the hands ( 100 HH ).
If i choose a bigger sample I can go to the gym before the result shows up in the handscolumn...
A Postgre-process starts up immediately after I open a new window and taking 50-60% of CPU until the hands show up.

My setup is:
W7 64, 4Gb RAM, T6400 CPU, postgre 8.3, HEM pro 1.11.01, Ladbrokes.

Best Regards J

Sarek
05-25-2010, 02:16 PM
see link in my signature

J-Oddjob
05-25-2010, 02:33 PM
I can see all the links but Iīm not sure where to start.
Delete winnernames, winningcards, upgrade PSQL to 8.4 etc..?
I havenīt had this problem in the past 2 years it just showed up recently.

Sarek
05-25-2010, 02:49 PM
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html

try all indicated in a row

J-Oddjob
05-25-2010, 03:43 PM
I have done several of the tips ( vacuum, disabled logging in pSQL, defrag often, increased those memory settings in psql-conf. etc ).
But it really didnīt increased performance.
Then i tried to disable those 3 stats in the hands view column and that really helped out.
Now it takes about 2 seconds to open the 1100 hands I have played today, it took 15 minutes before.