**Official uNL Microbrew thread: September**

[traz]

[ QUOTE ]
[ QUOTE ]
Not me, what I was wondering though, my PT database has around 100k hands now, and I just ordered my new pc:

a e6750 core 2 duo with 2 gig.

But how big can it get, before things start to crash on me? Having stats backed by 1k+ hands on people is always nice, but how long will it last?

[/ QUOTE ]

PostgreSQL. Change to it. My database is huge, takes a minute to open and switch tabs if not filtered but it is fine. If I had it to do over again I would separate it out by sites. I have 1.5 million hands and only 1gb of PC3200 ram.

[/ QUOTE ]

i'm pretty clueless, so what does this mean and how do I do it :P

[Nogatsira]

Are you serious on that last hand??
What does that 6 has to do with the hand?

[MrWooster]

I quite like the check behind - there are a ton of hands that could have you crushed just waiting to c/r the river - but I think it is quite close.

[dirtylobster]

[x] Owned

PokerStars Game #11998232150: Hold'em No Limit ($0.25/$0.50) - 2007/09/11 - 13:23:28 (ET)
Table 'Buryatia' 6-max Seat #6 is the button
Seat 1: glah ($48.50 in chips)
Seat 2: r_u_ready888 ($17.60 in chips)
Seat 3: Gherkinz ($46.65 in chips)
Seat 4: Frank4Fing3r ($23.75 in chips)
Seat 5: IM_MR_SHARK ($55 in chips)
Seat 6: dirtylobster ($50 in chips)
glah: posts small blind $0.25
r_u_ready888: posts big blind $0.50
*** HOLE CARDS ***
Dealt to dirtylobster [Kc Td]
Gherkinz: folds
Frank4Fing3r: folds
IM_MR_SHARK: calls $0.50
dirtylobster: raises $1.75 to $2.25
glah: folds
r_u_ready888: folds
IM_MR_SHARK: calls $1.75
*** FLOP *** [3h Th 4c]
IM_MR_SHARK: bets $2.75
dirtylobster: raises $8.75 to $11.50
IM_MR_SHARK: calls $8.75
*** TURN *** [3h Th 4c] [4s]
IM_MR_SHARK: bets $41.25 and is all-in
dirtylobster said, "lol?"
dirtylobster: calls $36.25 and is all-in
*** RIVER *** [3h Th 4c 4s] [2s]
*** SHOW DOWN ***
IM_MR_SHARK: shows [7d 7s] (two pair, Sevens and Fours)
dirtylobster: shows [Kc Td] (two pair, Tens and Fours)
dirtylobster collected $97.75 from pot
*** SUMMARY ***
Total pot $100.75 | Rake $3
Board [3h Th 4c 4s 2s]
Seat 1: glah (small blind) folded before Flop
Seat 2: r_u_ready888 (big blind) folded before Flop
Seat 3: Gherkinz folded before Flop (didn't bet)
Seat 4: Frank4Fing3r folded before Flop (didn't bet)
Seat 5: IM_MR_SHARK showed [7d 7s] and lost with two pair, Sevens and Fours
Seat 6: dirtylobster (button) showed [Kc Td] and won ($97.75) with two pair, Tens and Fours

[tehDiceman]

[ QUOTE ]
Are you serious on that last hand??
What does that 6 has to do with the hand?

[/ QUOTE ]

the SPADE completes a backdoor flush, he could have a straight as well.

[ QUOTE ]
I quite like the check behind - there are a ton of hands that could have you crushed just waiting to c/r the river - but I think it is quite close.

[/ QUOTE ]

that was my thinking and i didnt want to go and blow the session with a greedy play.

[tehDiceman]

[ QUOTE ]
[ QUOTE ]
[ QUOTE ]
Not me, what I was wondering though, my PT database has around 100k hands now, and I just ordered my new pc:

a e6750 core 2 duo with 2 gig.

But how big can it get, before things start to crash on me? Having stats backed by 1k+ hands on people is always nice, but how long will it last?

[/ QUOTE ]

PostgreSQL. Change to it. My database is huge, takes a minute to open and switch tabs if not filtered but it is fine. If I had it to do over again I would separate it out by sites. I have 1.5 million hands and only 1gb of PC3200 ram.

[/ QUOTE ]

i'm pretty clueless, so what does this mean and how do I do it :P

[/ QUOTE ]

are you on the pokertracker forum? go there and find the section directed towards postgresql. there are some tutorials about setting up and converting your databases.

you may have a little bit of trouble setting it up, but if you stick with it and make it happen, you'll be happy with the decision.

[traz]

ok cool, i'll look into it tonight. Can't stand the long times associated with big DB's, especially when i have a ton of datamined hands

[Nogatsira]

[ QUOTE ]
[ QUOTE ]
Are you serious on that last hand??
What does that 6 has to do with the hand?

[/ QUOTE ]

the SPADE completes a backdoor flush, he could have a straight as well.


[/ QUOTE ]

ok but isnt that monsters under the bed?

[fozzy71]

[ QUOTE ]
ok cool, i'll look into it tonight. Can't stand the long times associated with big DB's, especially when i have a ton of datamined hands

[/ QUOTE ]

I still use Access PT DB's. I could never get PostregSQL to work properly.

I use Realtime HUD for datamining of observed hands. PT only imports the hands I actually play. My HUD obviously has the stats from both datamined, and my PT DB. This keeps my PT Acccess DB smaller.

I know many people that use PA HUD - will have multiple PT DB's. One DB For datamined hands, and one DB for the hands they play. Their PAHUD can read from both PT DB's to accumulate stats for the HUD.

[wingchunflush]

TODAY IS MY BIRTHDAY. I am officially old and I know its the worst birthday ever. Stupid Jihad (spelling)