Quote:
Originally Posted by Poughkeepsie
Does anyone know the correct stat in PT4 for the river bet size when a raise occurs?
I would use:
cash_hand_player_statistics.amt_bet_r
However, when there is a river 2bet, that becomes equal to the 2bet size (aka:
cash_hand_player_statistics.amt_r_raise_made).
To be clear:
Pot:0.5
Villain bets: 0.3
I raise: 1.2
Villain folds
How to obtain villain betsize?
cash_hand_player_statistics.amt_bet_r is the total amount bet by a player on the river so it includes all bets, raises and calls on that street. Also anything using
'cash_hand_player_statistics' is specific to the player the statistic/filter is written for and it's not clear to me from whose perspective you need this. If you are writing the statistic/filter for villain then you can use:
cash_hand_player_statistics.amt_r_bet_made
if it's from heros perspective you can use:
cash_hand_player_statistics.amt_r_bet_facing
Quote:
Originally Posted by g3r4rd0x
my DB is too big 76GB i just wanna keep this year hands but dont wanna lose my notes or marked hands, this purge option is ok for that?
If you purge hands then you will lose marked hands/hand notes that are attached to any hands that are purged. Also if as a result of a purge there are no hands left for a player you would lose the player notes for that player.
Based on the size of your database it would be quicker to reimport the hands you want into a new database as purging a large amount of hands from a database of that size will take some considerable time and you will also need a large amount of free space on your disk for PostgreSQL to complete the necessary database maintenance afterwards.
Unfortunately there isn't a way to transfer marked hands when reimporting hands although you can export/import manual player/hand notes via the 'Database -> Notes' menu option. The only alternative I can suggest is to export your marked hands from a custom report and you can then import and mark them in another database (before importing the remainder of hands you want to transfer).
- Rob