Have you tried the built in HM2 > Maintenance > PostgreSQL Tuning feature yet?
We do not recommend any PostgreSQL above 9.0.x so you should probably try replacing 9.1.x with 9.0.x
You can also safely disable the postgresql logging since we usually do not need or ask for those logs so I will include those instructions at the end of my reply.
For the HUD issues:
Please disable the auto-center option in the pokerstars client as shown in this image - starsautocenter01 - fozzy71's library
*Note: If you have more than 1 pokerstars.xx client installed you need to do the steps above and below for all of the pokerstars.xx clients.
We do not currently support the auto center option at poker stars but it is on our list of things to add support for in the future.
Configure your poker client preferred seating and seating preferences in HM accordingly.
http://hm2faq.holdemmanager.com/ques...ng+Preferences
*Note that the Seating Preferences have been moved to the new Site Setup menu - http://hm2faq.holdemmanager.com/ques...Setup/VXTxky9K
1) Open one Table, play at least one hand.
2) Move the stats with the right mouse key to the correct positions - http://hm2faq.holdemmanager.com/ques...tcuts#movehuds
3) Now you can open further tables but you will always have to play at least one hand for the stats to be moved to the correct positions.
The easiest way to align the HUD is to use the Arrow Buttons (< >) on the Table Averages HUD to rotate your HUD where it belongs.
After you have installed postgresql 9.0:
Logging:
To turn off logging, follow these instructions. This is the first thing I do anytime I install SQL for someone.
- Start > My Computer > Tools > Folder Options > View > UnCheck 'Hide Extensions for known file types' > OK
- C:\Program Files\PostgreSQL\data\postgresql.conf > Right-Click > Open With.. > NotePad > Check 'Always use this program'
- Scroll about half way down to ~Lines 245 - 260:
- The last line of this block of code, for the 'logging_collector', must be changed from On to Off.
HTML Code:
------------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#------------------------------------------------------------------------------
# - Where to Log -
log_destination = 'stderr' # Valid values are combinations of
# stderr, csvlog, syslog and eventlog,
# depending on platform. csvlog
# requires logging_collector to be on.
# This is used when logging to stderr:
logging_collector = off # Enable capturing of stderr and csvlog
File > Save; File > Close
Start > Programs > PostgreSQL 8.3 > Reload Configuration.
- Start > My Computer > C:\Program Files\PostgreSQL\data\pg_log, or C:\Program Files (x86)\PostgreSQL\data\pg_log, if you have 64 bit Vista. Delete all files in that folder. And it might be a good idea to empty your recycle bin at that point.
Regarding database maintenance:
You should regularly vacuum/reindex your database if using notecaddy but you should NOT ever defrag your SSD's (I assume you probably know this but posting it in case anyone else reads this).