HOW TO MAKE POKERTRACKER FLY . . . . (well almost)

[kes1981]

With so much free time, I have been messing around with this to optimize my database for my system (I have been using your top config with great results)

My rig: i7-2600k overclocked to 4GHz, 16 GB of DDR3 RAM no overclock, OCZ Vertex SSD

The hands are all at 400PLO -1000PLO; I think the game matters since most hands see flops and these affects import times)

512MB shared buffers
128MB work_mem
512MB maintenance_work_mem
2048MB effective cache size
8MB wal_buffers
24MB temp_buffers

Hands Imported 525490
Time 14:48
Hands/second 591.77 h/s

1024MB shared buffers
128MB work_mem
512MB maintenance_work_mem
2048MB effective cache size
8MB wal_buffers
24MB temp_buffers

FAILED TO START SERVICE

768MB shared buffers
128MB work_mem
512MB maintenance_work_mem
2048MB effective cache size
8MB wal_buffers
24MB temp_buffers

Hands Imported 525490
Time 14:55
Hands/second SLOWER

512MB shared buffers
128MB work_mem
1024MB maintenance_work_mem
2048MB effective cache size
8MB wal_buffers
24MB temp_buffers

Hands Imported 525490
Time 15:03
Hands/second SLOWER

512MB shared buffers
128MB work_mem
768MB maintenance_work_mem
2048MB effective cache size
8MB wal_buffers
24MB temp_buffers

Hands Imported 525490
Time 15:01
Hands/second SLOWER

So far your config wins... I'm just getting started though. Any recs based on my rig?

[kes1981]

Does it matter if I'm using postgresql 8 (the one that came with the pt3 download) and I'm importing from my primary drive? My desktop is only for poker so I keep all poker stuff on the ssd; I read that importing from a secondary drive would be faster.


Finally, how do I impact read speeds; HUD updates, report loadings, etc....

[kraada]

Upgrading to 9.0 will help you with that setup perhaps even more than further configuration file tinkering.

[Germaniac2]

.
Hi kes1981,

Great results. Since I'm a cheap bastard and have been using AMD vs. Intel CPUs for cost considerations for a while,
I can't really tell you anything specific in regard to your rig. However, at close to 600H/s you're doing just fine, and
importing 1/2 million hands in under 15 minutes is nothing to sneeze at. It also looks like finally going from 8GB to
16GB RAM might do me some good. I definetly agree with kraada, that moving to the 64-bit version of PostgreSOL
will probably do far more for you than any further tinkering with the configs will. I've been using it for about 4 months
now without any issues; its stable and seems to have improved overall performance slightly (5-10%). So if you are running
a 64-bit version of windows, going to 9.0 would be your best move.

The most important thing left for all of us here in the US to do at this point is to exert whatever influence (i.e. phonecalls & emails)
we can to get our so-called representatives in congress to move on the legislation proposed on March 18, 2011. Meanwhile its time to
squeeze out some lunch money, a couple of bucks at a time, from the local yokels at the B&M around the corner.

PS: Which data provider do you use? (Based on your import speeds their files seem to be in better order than other's.)
.

[kes1981]

I think the format is slowing me down based on earlier posts. They aren't in order; jumping around from table to table:

PokerStars Game #60798697413: Omaha Pot Limit ($2/$4 USD) - 2011/04/14 0:00:36 ET
Table 'Triglav VII' 6-max Seat #4 is the button
Seat 1: xblumpkin ($400 in chips)
Seat 2: Chaper07 ($568 in chips)
Seat 4: DanHasAPlan ($266.30 in chips)
Seat 5: kes1981 ($400 in chips)
kes1981: posts small blind $2
xblumpkin: posts big blind $4
broseph321: sits out
*** HOLE CARDS ***
Chaper07: folds
DanHasAPlan: raises $8 to $12
kes1981: folds
xblumpkin: folds
Uncalled bet ($8) returned to DanHasAPlan
DanHasAPlan collected $10 from pot
DanHasAPlan: doesn't show hand
*** SUMMARY ***
Total pot $10 | Rake $0
Seat 1: xblumpkin (big blind) folded before Flop
Seat 2: Chaper07 folded before Flop (didn't bet)
Seat 4: DanHasAPlan (button) collected ($10)
Seat 5: kes1981 (small blind) folded before Flop




PokerStars Game #60798690263: Omaha Pot Limit ($2/$4 USD) - 2011/04/14 0:00:12 ET
Table 'Mette VI' 6-max Seat #6 is the button
Seat 1: KingKobra ($384 in chips)
Seat 2: antchev ($418 in chips)
Seat 3: Donkaroo22 ($424 in chips)
Seat 4: Aufangzeb ($525.65 in chips)
Seat 6: xblumpkin ($1001 in chips)
KingKobra: posts small blind $2
antchev: posts big blind $4
*** HOLE CARDS ***
Donkaroo22: folds
broseph321 joins the table at seat #5
Aufangzeb: folds
xblumpkin: raises $8 to $12
KingKobra: folds
antchev: folds
Uncalled bet ($8) returned to xblumpkin
xblumpkin collected $10 from pot
xblumpkin: doesn't show hand
*** SUMMARY ***
Total pot $10 | Rake $0
Seat 1: KingKobra (small blind) folded before Flop
Seat 2: antchev (big blind) folded before Flop
Seat 3: Donkaroo22 folded before Flop (didn't bet)
Seat 4: Aufangzeb folded before Flop (didn't bet)
Seat 6: xblumpkin (button) collected ($10)




PokerStars Game #60798687534: Omaha Pot Limit ($2/$4 USD) - 2011/04/14 0:00:02 ET
Table 'Malzovia III' 6-max Seat #3 is the button
Seat 1: antchev ($1931.95 in chips)
Seat 2: Aufangzeb ($424.20 in chips)
Seat 3: AlxPrada 1st ($298.15 in chips)
Seat 4: xblumpkin ($465.65 in chips)
Seat 5: KingKobra ($400 in chips)
Seat 6: GSS1966 ($1044.95 in chips)
xblumpkin: posts small blind $2
KingKobra: posts big blind $4
*** HOLE CARDS ***
GSS1966: folds
antchev: folds
Aufangzeb: folds
AlxPrada 1st: raises $6 to $10
xblumpkin: raises $24 to $34
KingKobra: folds
AlxPrada 1st: folds
Uncalled bet ($24) returned to xblumpkin
xblumpkin collected $24 from pot
xblumpkin: doesn't show hand
*** SUMMARY ***
Total pot $24 | Rake $0
Seat 1: antchev folded before Flop (didn't bet)
Seat 2: Aufangzeb folded before Flop (didn't bet)
Seat 3: AlxPrada 1st (button) folded before Flop
Seat 4: xblumpkin (small blind) collected ($24)
Seat 5: KingKobra (big blind) folded before Flop
Seat 6: GSS1966 folded before Flop (didn't bet)


I overclocked to 4.4 stable and upgraded to 9.0. Will run further test. GOD DAMN I'M BORED.

[kraada]

That will definitely slow things down - if you're hard core enough you could try writing a script to reorder the hands so that all of the hands from the same table are together.

But we do really appreciate hearing the results of all of these tests, so definitely keep following up here.

We our power users!

[kes1981]

That will definitely slow things down - if you're hard core enough you could try writing a script to reorder the hands so that all of the hands from the same table are together.

But we do really appreciate hearing the results of all of these tests, so definitely keep following up here.

We our power users!

Not a power user; just a poker player with way too much free time.

I finished my first run with the first setting with the same HH batch I used in my prior post and DAMN: 705.8 h/s

I have no clue if it's PostgreSQL 9 or the overclock to 4.4, but I'll take it. I even had HEM importing at 260 h/s!!!!!

[zubs1aa]

play more, ++++EV > mess with PC.

you must be really bored like you said

[kraada]

Now you're just making me drool - I have to get me an SSD sometime this year.

[zubs1aa]

Now you're just making me drool - I have to get me an SSD sometime this year.

seems like a business expense to me?