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:
Could somebody adapt this set of commands to optimize a holdemmanager postgres database?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;"