PDA

View Full Version : Cluster postgres database to increase performance?



e306
10-08-2008, 07:39 AM
Hey guys.

Back when i used Pokertracker2, i performed database-clustering once a month and the DB-speed became SO MUCH faster!
here is what i did:



attention! this is for Pokertracker2 - NOT FOR HOLDEMMANAGER!
"c:\program files\postgresql\8.0\bin\psql" -d "YOUR_DB_NAME" -U postgres -c "cluster session_idx_02 on session;"
"c:\program files\postgresql\8.0\bin\psql" -d "YOUR_DB_NAME" -U postgres -c "cluster player_winnings_idx_02 on player_winnings;"
"c:\program files\postgresql\8.0\bin\psql" -d "YOUR_DB_NAME" -U postgres -c "cluster player_idx_02 on players;"
"c:\program files\postgresql\8.0\bin\psql" -d "YOUR_DB_NAME" -U postgres -c "cluster game_idx_01 on game;"
"c:\program files\postgresql\8.0\bin\psql" -d "YOUR_DB_NAME" -U postgres -c "cluster game_players_idx_05 on game_players;"


Could somebody adapt this set of commands to optimize a holdemmanager postgres database?

DK115
10-09-2008, 02:34 AM
@morny, are you investigating this?

morny
10-09-2008, 11:36 AM
Yeah ive forwarded this onto Roy however hes extremely busy over the next few days but hell be along to respond as soon as he has some free time.

debakel3
10-29-2008, 11:00 AM
is there any progress?

morny
10-29-2008, 04:29 PM
Sorry this must have slipped through ill remind him again

Rvg72
10-30-2008, 01:04 AM
Hi, there is no clustering with HM at the moment but make sure you have a recent build because the new optimization for hero's makes reports almost instant on large db's.

Please download the latest beta from http://www.holdemmanager.com/downloads/HmUpdate1.06.04beta.exe