Cluster postgres database to increase performance?

[e306]

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]

@morny, are you investigating this?

[morny]

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]

is there any progress?

[morny]

Sorry this must have slipped through ill remind him again

[Rvg72]

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/downloa....06.04beta.exe