View Full Version : optimizing reports every time on start up
roeky
07-25-2010, 05:30 PM
hm keeps bringing up this same screen when i start
http://imgcentre.com/img/uploads/small/05abdeb6b9.png (http://imgcentre.com/images/view/05abdeb6b9.png)
_Loki_
07-25-2010, 07:10 PM
If you get an error similar to the one in the screenshot below, then your index has become damaged.
http://faq.holdemmanager.com/images/index-01.jpg
You first need to identify what index is damaged. It will be in quotes, so we can see from the above error that the index damaged is playershandscashmisc_idx1. Please take note of which index is damaged, as you'll need it shortly.
To fix your index, do the following:
1. Launch Holdem Manager if you haven't already.
2. Navigate to Options > Database Management. The Database Control Panel dialog should pop up as shown below:
http://faq.holdemmanager.com/images/index-02.jpg
3. Enter your password if necessary and click on Connect.You should see the following screen.
<w:wrap></w:wrap>
4. Click on the Fix Indexes button. The Rebuild Indexes dialog should pop up.
<w:wrap></w:wrap>
http://faq.holdemmanager.com/images/index-04.jpg
5. Select the applicable index from the dropdown list and then click on Rebuild. Please be patient, as it can take some time on larger databases. When it's complete you'll see the following dialog:
<w:wrap></w:wrap>
http://faq.holdemmanager.com/images/index-05.jpg
Your Index is now fixed.
Click on close and restart Holdem Manager.
Note: If you have several damaged indexes, you'll need to repeat these steps until it's complete.
_Loki_
07-25-2010, 07:13 PM
If HM does not allow you to access the dialogs as shown you can reindex via pgAdmin
roeky
07-25-2010, 08:53 PM
thanks i finished that but my hands aren't showing up but the sessions are
http://imgcentre.com/img/uploads/small/f40b29278a.png (http://imgcentre.com/images/view/f40b29278a.png)
_Loki_
07-25-2010, 09:11 PM
###
Yes that's usually because you need to optimise some stuff...
###
Do the postgreSQL section of here if you feel you can:
>> FAQ - Hold'em Manager Poker Tracking Software :: Holdem Manager Performance & Speed Tweaks (http://faq.holdemmanager.com/questions/373/Holdem+Manager+Performance+%26+Speed+Tweaks)
###
These will help too - especially 1]
1] Remove the WinnerName, WinnerCards and WinnerWon from the Hands View Column Selector (http://faq.holdemmanager.com/questions/192/Hands+View+Column+Selection)
2] Purge hand histories (http://faq.holdemmanager.com/questions/196/Observed+Hand+History+Configuration) (It will free up disk space without losing stats, but you lose the option to see the HH or view the hand in the replayer)
3] vacuum/analyse full
4] close running progs as much as possible (including postgreSQL service)
5] Defrag
6] Reboot PC
###
roeky
07-25-2010, 11:13 PM
ok i can see the hands now but i tried to run the vacuum and analyze abd i have to press ok every five minutes. i had to quit after 2 hours
i tryed to import hands to hm and all i got was import errors
_Loki_
07-25-2010, 11:35 PM
###
I'm 90% sure you have a corrupt DB
Create a new DB & import some hands
Set hero name
close/open HM
test
FAQ - Hold'em Manager Poker Tracking Software :: Database Management (http://faq.holdemmanager.com/questions/190/Database+Management)
FAQ - Hold'em Manager Poker Tracking Software :: Create / Delete Database (http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database)
###
roeky
07-27-2010, 12:04 PM
i made a couple of changes to optimize
Recommended changes:
shared_buffers = MB (set this to 20% of your system memory, but not more than 1000 MB.... round it off to 128 MB, 256 MB, 512 MB or 768 MB)
effective_cache_size = MB (set this to 2x the size of the shared_buffers)
i started a new db and everything worked fine
and now today postgresql wont start in services. Im using an external hd for my db
http://imgcentre.com/img/uploads/small/54590d12ec.png (http://imgcentre.com/images/view/54590d12ec.png)
i tried uninstall/reinstalling sql but that didnt work
fozzy71
07-27-2010, 10:59 PM
External drives are notoriously unstable for sql db's with HM.
FAQ - Hold'em Manager Poker Tracking Software :: Can't Connect / Failed to Start PostgreSQL (http://faq.holdemmanager.com/questions/91/Can't+Connect+%7B47%7D+Failed+to+Start+PostgreSQL+ )
First try to reboot.
If no help, try this:
Start > Programs > PostgreSQL > 8.x > Stop Service
Start > Programs > PostgreSQL > 8.x > Start Service
If that doesnt help delete the \postgresql\8.x\data\postmaster.pid file, if you see it.
Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily - FAQ - Hold'em Manager Poker Tracking Software :: Windows Firewall / Defender Problems (http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems)
Please try following these FAQs, step by step:
1) FAQ - Hold'em Manager Poker Tracking Software :: Can't Connect / Failed to Start PostgreSQL (http://faq.holdemmanager.com/questions/91/Can't+Connect+%7B47%7D+Failed+to+Start+PostgreSQL+ )
2) reinstall the same version of postgresql, using the same \data folder - FAQ - Hold'em Manager Poker Tracking Software :: Reinstall PostgreSQL Preserving Old Database (http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+Database)
3) Still Can't Connect to PosgreSQL? Try This! - Holdem Manager Forums (http://www.holdemmanager.net/forum/showthread.php?t=8261)
If that doesn't help you will probably have to reinstall PostgreSQL completely and reimport your hands using these instructions
1) Uninstall PostgreSQL from the Windows Control Panel.
2) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://www.holdemmanager.com/downloads/Holdem_Manager_Setup.exe
If that installer fails to install PostgreSQL, please reinstall PostgreSQL using the following instructions:
A) Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator
net user postgres /delete
B) Reboot.
C) Try installing this version of PostgreSQL - http://www.holdemmanager.com/downloads/Postgres_8.3.9-v1.0.7.exe
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.