PDA

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&#039;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&#039;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