My database is down and I can't get up!

magithighs

My pokertracker database seemed to have reached it's limits, so I installed the Postresql version.  I started converting my database at 10:30 am and it's still running.  Would you believe I've played against 1,000,000 players last year?  Apparenly I have, and it's at 800,000 right now.  Yikes! 

Ooops just another post to proclaim how great I am and absolutely nothing to do with letting you know that you should convert early if you plan on building a big pokertracker DB (> 100,000 hands) .  Thank goodness I get $$s for this post.

Cheers
Magi

ScottyZ

My database is down and I can't get up!

Did you push your LifeCall button in order to summon your neighbour's dog for assistance?

ScottyZ

beanie42

I switched to postgres before I even started using PT, so I should be OK . Just remember to vacuum/analyze regularly in order to maintain performance.

Lou - with the amount you use PT and the size of your db, do you have any performance issues? What hardware are you using, and have you tweaked postgres.conf at all or are you just running the defaults? Once you've used it for a little bit, I'd be interested in knowing how it runs for you.

Hork42

magithighs wrote:

Would you believe I've played against 1,000,000 players last year?

Uhh. No. I can honestly say I don't believe you've played against 1 million different opponents. Show your work please.

magithighs

Hork42 wrote:

magithighs wrote:

Would you believe I've played against 1,000,000 players last year? 

Uhh.   No.  I can honestly say I don't believe you've played against 1 million different opponents.   Show your work please.

Ah, well I'm like a hooker -- I only show for dough!

Cheers
Magi

magithighs

beanie42 wrote:

I switched to postgres before I even started using PT, so I should be OK .  Just remember to vacuum/analyze regularly in order to maintain performance. 

Lou - with the amount you use PT and the size of your db, do you have any performance issues?  What hardware are you using, and have you tweaked postgres.conf at all or are you just running the defaults?  Once you've used it for a little bit, I'd be interested in knowing how it runs for you.

I haven't worked with databases in over 15 years -- so do I really have to vacuum?

Yes, the Access DB was extremely slow and cumbersome.  That's why I upgraded to sql.  I'm running it on a normal Dell Laptop 1.6 gh.   And, I used all the sql defaults.  Once I'm up and running I'd love to exchange notes on how to tweak performace -- would be much appreciated on my part.

On a postive note, it's up to 800,000 on the player table!  Only 271,000 to go!

Cheers
Magi

magithighs

ScottyZ wrote:

My database is down and I can't get up!

Did you push your LifeCall button in order to summon your neighbour's dog for assistance?

ScottyZ

Unfortunately, no.  But my two cats are looking at me in a strange sort of way -- they know I'm in distress but they don't give a crap.

Cheers
Magi

beanie42

magithighs wrote:

I haven't worked with databases in over 15 years -- so do I really have to vacuum?

Unfortunately, yes. PT will remind you every week or so, but depending how often you're playing, you may want to do it more. I have mine setup to vacuum automatically every night which is probably a bit aggressive (although I have my work servers vacuum every 4 hours). With the amount you play, every day or 2 probably makes sense.

magithighs wrote:

Once I'm up and running I'd love to exchange notes on how to tweak performace -- would be much appreciated on my part.

My boss actually hired a former postgres developer to spend a few hours with me and show me how to optimize it. I'm no expert, but hopefully good enough. And trading a bit of my postgres knowledge for your poker knowledge is definately a bargain

zero

Ugh, I didn't even know I'd have to convert this eventually. I guess I should do it soon since I'm at 100,000 hands. Sigh, another random program I've never heard of that I need to figure out...

stpboy

Hork42 wrote:

magithighs wrote:

Would you believe I've played against 1,000,000 players last year? 

Uhh.   No.  I can honestly say I don't believe you've played against 1 million different opponents.   Show your work please.

It could be that he has just played with 1 million (pinky to lip) different user names. Same oponents, different accounts and different sites. I don't find it hard to believe.

On a side note, why do you and BBC feel the need to continue to question Lou so much? Well, nevermind about BBC (I know his reasons) but you Chris? I'm going to rename you two Axe and Smash from the old WWF days. DEMOLITION!!!

Those guys were great, for wrestling.

stp

Hork42

It could be that he has just played with 1 million (pinky to lip) different user names. Same oponents, different accounts and different sites. I don't find it hard to believe.

Do the math. That's unpossible. Are you counting a 10,000 person freeroll where you import all the names for all the tables? That's a lot of table jumping to "play" with that many different opponents in a year. Hit-n-run! WOW.

On a side note, why do you and BBC feel the need to continue to question Lou so much?

I question things that don't make sense to me. If I see bullshit I'm going to call it. And I do it anytime I see it, this isn't focused at any one person in particular. Does Lou think I'm "continually questioning" him? If he does, he can speak up for himself. We've seen him defend himself in the past.

stpboy

Hork42 wrote:

I question things that don't make sense to me.  If I see bullshit I'm going to call it.   And I do it anytime I see it, this isn't focused at any one person in particular.  Does Lou think I'm "continually questioning" him?   If he does, he can speak up for himself.  We've seen him defend himself in the past. 

Ok, thats a fair answer. I didn't do the math and actually don't use poker tracker. I, being the poker player I am, notice trends. I thought I saw one here and wanted to point it out. I don't talk to Lou very much, just the odd tournament I see him at. I know he can defend himself, I just thought I had enough history here to question why....

Not a big deal though, I was just asking.

stp

beanie42

To put it in perspective, PT counts each account as a player. I count as 4 players because of my accounts on 4 sites. I've only been using PT since Dec.6 (just over a month) and I have over 50,000 players in my db (I have cleared non-moneying, no HH tourney players). As a join a few more sites and play a bit more (and hopefully move up in limits), I fully expect this to grow, and realistically I can see 250K by the end of the year. Since that makes sense for me as a casual player, I can easily see somebody playing full-time hitting a million.

Hork42

When you start using PT and build your database the # of players is going to rapidly increase. But there's a limit to how much it's going to grow because you will begin to see the same players playing at your games over and over.

moose

beanie42 wrote:

To put it in perspective, PT counts each account as a player.  I count as 4 players because of my accounts on 4 sites.  I've only been using PT since Dec.6 (just over a month) and I have over 50,000 players in my db (I have cleared non-moneying, no HH tourney players).  As a join a few more sites and play a bit more (and hopefully move up in limits), I fully expect this to grow, and realistically I can see 250K by the end of the year.  Since that makes sense for me as a casual player, I can easily see somebody playing full-time hitting a million.

I don't get how you can have so many players in your DB either. I've been using PT for about 8 months. I have about 12 000 players in the DB over 43 000 hands played. I am guessing you haven't even played 10 000 hands yet in your DB. You must somehow be data mining tables without actually playing these people.

beanie42

moose wrote:

I don't get how you can have so many players in your DB either.  I've been using PT for about 8 months.  I have about 12 000 players in the DB over 43 000 hands played.  I am guessing you haven't even played 10 000 hands yet in your DB.  You must somehow be data mining tables without actually playing these people.

Thanks for the info Moose. I have played a few more hands than you think (5K ring and 10K tourney) and I'm not data-mining, but I can't see having more players then you either. However, I do play a lot of MTT's, and with 10% moneying, I think PT will keep those even with purging (so an avg tourney of 1000 players will net me 150 money-winners). I'm getting a new laptop in the next few days and will be moving the db, so I'll re-clean it and check it, since that does seem pretty high in comparison (and knowing how much you play ).

magithighs

beanie42 wrote:

moose wrote:

I don't get how you can have so many players in your DB either.  I've been using PT for about 8 months.  I have about 12 000 players in the DB over 43 000 hands played.  I am guessing you haven't even played 10 000 hands yet in your DB.  You must somehow be data mining tables without actually playing these people.

Thanks for the info Moose.  I have played a few more hands than you think (5K ring and 10K tourney) and I'm not data-mining, but I can't see having more players then you either.  However, I do play a lot of MTT's, and with 10% moneying, I think PT will keep those even with purging (so an avg tourney of 1000 players will net me 150 money-winners).  I'm getting a new laptop in the next few days and will be moving the db, so I'll re-clean it and check it, since that does seem pretty high in comparison (and knowing how much you play ).

I think the MTT are the place large numbers of players are picked up.  I play allot of those Sunday tournaments with over 4K players and then I was playing allot of the $3 rebuys, and $11 rebuys.  It makes for a ton of players.  I also play a wide range of limits, so that will increase numbers.  I'm checking with Pokertracker Pat to see if there's a way to purge some of these players as I really don't care about xyz who played one hand with me on a $3 rebuy a year ago. 

I'll keep ya posted.

Cheers
Magi

ScoobyD

I think a million could be doable (although it does sound like a ton). I have about 15k from ring (about 75k hands) and 37k from tourneys and I've been using PT for about a year. That being said I don't even play that many multies, but a decent number of single table SNGs. And most of that is just between 3 sites (with basically all my tourneys on Stars). I'd guess if you were playing on several sites (and playing MTTs on several sites) it would be doable. I'd guess Magi plays a significant amount more than I do anyways.

beanie42

magithighs wrote:

I'm checking with Pokertracker Pat to see if there's a way to purge some of these players as I really don't care about xyz who played one hand with me on a $3 rebuy a year ago. 

I'll keep ya posted.

Yes, please do let us know what you find. Since I prefer the MTT's, I'd like to keep my db as empty as possible as well.

moose

Ok so it must be the tourneys. I don't play a lot of tourneys and those that I do - PT can't import the tourney stats (Pokerroom for eg). Ok to keep your DB smaller:
1. Under autorate players - set the hands played value higher. This won't make the database smaller but I match the number here to the value in step 2. Also don't autorate yourself and then the DB will run faster on every import.
2. Under Utilities - Database Maintenance and Options - Hide Ring Players, there are two settings - Hide players with less than XXX hands played AND who have not played since: XX/XX/XXXX and similarly for Hide Tourney Players. On the Ring Hands page - use the Purge Players button as well.

Beanie how do you hide the players that did not money?

beanie42

moose wrote:

Beanie how do you hide the players that did not money?

Under "File" -> "Poker Stars Tournament Results - Manual Entry", there is a button on right middle to delete players.

moose

Thanl you very much for the info Beanie.