Nope, thanks for the reply. But I didn't have auto-import on.

Oh, just the image posted clearly shows it was on at time of that snap shot but whatever.

OK, i'm not one to usually go off on one, but Ive basically had enough now. Can I please have a refund as I'm buying HEM today. I'm not even that bothered about the $80, as PT3 has probably cost me nearly $1k in equity whilst the thing freezes up and times me out in big pots, but just in principle I would like it back.

Build two freezes so much and the HUD randomly dissapears and then the whole thing just closes down and locks up my whole computer. And the new Beta is literally impossible to use, I don't even understand why you'd ever bring this out and actually charge people for it?

anyway, onwards to HEM! my housemates have been laughing at me for weeks now for using PT3, I stuck by it though because I loved PT2, but this is a compltelty different program that just doesnt work

Import working fine.
but: I can't cancel the manual import...
PT3 is not crashing but: Hud stops at some time and does not update anymore, new tables are not recognized... Any clue? I'm playing on party

Looking at the screencap, I notice the 'analyze on completion' was unchecked. Have you ever done an analyze? If you haven't that will slow things down. The other poster was right about duplicates (esp. duplicates + logging) slowing things down; if you can pull the dupes out it will speed things up. What version of PostgreSQL are you running? 8.3 is faster than 8.2 is much faster than 8.1 or previous.

Yes, though it's a little complicated at the moment. You need to create a custom statistic (custom statistics guide). However, if you look at the Database Schema there is a flg_p_sqeeze and flg_p_squeeze_opp (squeezes and squeeze opportunities) so it's a fairly simple custom statistic.

I've never seen worse than about 50 myself. You could also consider defragging your hard drive if you haven't in a while; PostgreSQL keeps data in lots of separate files and as those get scattered around the disc and it may degrade performance (note: you do need 15% of your HD free in order for defrag to work properly).

The spinning image next to the Import tab happens when doing manual imports as well.

You should be using the Auto-Import while playing. The manual import is for doing one time bulk imports and not for continuous play. Turn auto-import on and things will work better

For the record, the vast majority of the problems at this point are solely from the HUD. If you turn the HUD off things should be working properly. At which point you can try _dave_'s AHK HUD, which is currently free and available here.

(Before you quote me and ask again: I am not empowered to give refunds. You have to go through the support system.)

My big problem is after the application crashes (a few times a day) I restart it and then it imports all my hands again. Since the import is EXTREMELY slow when there are duplicates my HUD never updates properly on the tables I'm playing. Since I datamine FTP we're talking 15,000 - 20,000 hands I'm trying to import. Actually that number keeps increasing because I will usually be playing or datamining while it's reimporting so the next time there will be 25,000+ hands to reimport.

How can I stop it from importing all the hands again? Shouldn't it move them to the processed folder? I tried shutting PT3 down after the import process was complete but when I opened it back up it imported all 20,000 hands again. Do I have to manually copy the files to a new directory myself?

PT3 does not automatically move processed files if the processed files were imported via manual import. This will likely change but this is how it works for the time being. If you are using manual import (and for 20k hands it will be significantly faster to import with a manual import), you do need to move your processed files manually. If you are using auto import, the "Move Processed Files To:" box tells you where the files are going to go once you stop auto-import. You should make sure they go to a folder that is not looked at for new files by PT3 (C:\ProcessedHands\ or something). I recommend going through and manually moving all of your processed hands, and if you're currently playing or datamining just leave the Auto Import running while doing so. Then once you're finished playing/datamining just stop the Auto Import and the hands will be moved.

I still have this problem too - it happens on Stars when I multi-table and I hit the 'refresh' button to check my session details. The only workaround is to disable the HUD, hit refresh and this enable the HUD again.

I don't like that the HUD can affect the responsiveness of Pokerstars at all.

You could try Beta 12 to see if that works well for you. Beta 12 does fix the intermittedn Hero stats.

Sweet thanks i'll try it

I've already gone over this with Josh more than once... My com puter is pretty much brand new, and powerful (granted it only has a 7200 rpm HD) and I defrag at least once a week...

Finally after having a support ticket open for a while, he says to try to put the HH's in a folder that's not on the desktop. I do that and then get about 150hands/sec. Which is great... Problem solved right? LOL of course not


Now since I have to re-import everything yet again.
I try the a folder not on the desktop. ANd get 15hands/sec. I go to sleep wake up this morning, and it's at 7h/sec, with 12 hrs remaining. (and this is only for a 600k h db)
I can't wait to do my 4mil hand db....


Also, I tried probalby 5 different folders all over my computer hoping to duplicate that 150h/ssec
but no way, that was somehow a one time fluke i guess...

And I'd like to think I've been pretty patient also, but i'm afraid that is wearing thin...

I'd open another support ticket, but I have like 3 open since May 3, that have been ignored so whats the point

So, just to make sure I understand what's going on: when you moved to a folder not on the desktop you got good speeds once, and never again? Or do you get good speeds in the beginning and then it slows down? If it's the latter it might be something strange going on with one (or more) of the HH files you are using. Could you try breaking the HH files up into several different directories and then seeing if one directory imports much faster or slower than the others? The more information we can get on what exactly is going on the better.

I do understand your frustration and we do greatly appreciate your patience. We will get to every open ticket, including yours.

I got good speed once...
aside from that one time, I never get good speed starting off then it slows.
it does start off faster. like 15ish hands/sec, then slowly goes down. last night when I let it run all night, by this morning it had improted approx 270k hands, and the speed was down to 7h/sec

I think initially Josh thought it might have something to do with the large txt files PT3 makes when you export a db... But I dont' know if he ever found anything with that idea

any ideas on what directories to try??
I'm running vista 64bit.

I"ve tried main C: directory
I've tried:
C:\Users\myname\
C:\Program Files(x86)\Pokertracker3\
C:\Users\Postgres\
C:\Users\Public\


I really wish I could remember the exact directory I used a while ago to get the great import speeds...

What other info can I provide?

How big are the files you're trying to import, and how many of them are there?

They all vary between 3,880kb to 3,950kb give or take a couple kb's
(3k hands per file)

I've tried doing 5 at a time, i've tried doing them all at once... import speed do not vary.
Right at this very moment, i'm importing 5 files from C:\Windows\fold\ and I"m getting 6.8h/sec


Also, just to clarify, when I import, I'm NOT importing duplicate hands, which i know slows down the process

orentha, try files that have 300 hands in them. I get 60hps importing from my laptop to a database that exists on another computer when i use 300hands per file exports from PT2

just had a chance to test out Beta 12.
and wow, yuck. it's 5x worse then build 2.

I was only 5 tabling, and stats never popped up on 2 of the tables, through the whole session, only 3 tables even worked (and those 2 tables did have the PThud icon on them)

my own session stats absolutely never even showed up
if I ever attempted to drag a FT table, even just a half a cm, to line it up, it'd INSTAfreeze every table, and I'd timeout on them all... happened every time i tried to move a table

coulnd't click on the PT hud icon
it would open like normal probably 10% of the time. 40 % it would do nothing.
and the remaining 50% it would freze FT and i'd timeout on all my tables...

Cost me over a buyin just trying it out...

For some people it works a lot better, for some it works a lot worse. That's why it's a Beta currently not Build 3. We're trying to hammer out what's going wrong for the people for whom it works worse.

Also, I'm still looking at the HHs you sent me, just so that everybody else knows: it's something in his HH files that makes them import very, very slowly and I'm trying to track down exactly what. As soon as I have more concrete information on what it is that could be doing that, I'll let everybody know.

Thanks for the help guys, but I'm still having problems. I disabled logging, defragged, started a new database to avoid duplicates, etc.

Here is what my import window looks like now..



I'd also like to know why my Task manager says so many instances of postgres are running. The only thing program that runs it is PT3. Here is a pic...



... Could this be why my imports are so slow? How do I get rid of all these postgres functions?

Those postrgres.exe are supposed to be there, definitely don't do anything to them. I only have six running right now but I'm not using PT or anything database related so maybe more show up then or maybe your database is much bigger.

the HUD doesnt work at all for me on the 12 beta and on the build 2 HUD doesnt ususally show all the tables I run or it randomly shuts down on me stating theres an error, how can I fix this?

The new beta has imported some hands funny. Some say (6max ) or (2max) when their all full ring. How do I change this or delete the hands?

At the moment you can't remove just these hands. Selective purge will be added later.
The size of the table is determined on the first hand imported for a table, so if you open a ring table with few players it will be treated as 6-max.

You forgot to mention it's a bug and it's getting fixed.