Slow import speed with SSD

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Slow import speed with SSD

Postby spigot » Thu Sep 06, 2012 8:20 am

Hi!

Installed ssd and put windows 7 x64 there then installed postgres 9.0 and then pokertracker 3

after install imported my hands from this year and speed was 67 h/sec that seemed quite low (hands were read from that ssd)

today tried to play for first time and autoimport seemed to import at speed 1 hand / 5 sec and that caused so huge backlog that didn't even get stats to some tables at all during 45min session and program still imported 30min after I ended my session :P

any idea what's causing this and how to fix?
spigot
 
Posts: 8
Joined: Sun Mar 11, 2012 10:40 am

Re: Slow import speed with SSD

Postby kraada » Thu Sep 06, 2012 12:56 pm

Auto import isn't designed for speed - if you have large batches of hands you should be using Manual Import to import things.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Slow import speed with SSD

Postby spigot » Thu Sep 06, 2012 1:07 pm

???

so you are saying I should use manual import while I play? lol

can't imagine trying to regulary use manual import while 20-tabling
spigot
 
Posts: 8
Joined: Sun Mar 11, 2012 10:40 am

Re: Slow import speed with SSD

Postby kraada » Thu Sep 06, 2012 5:06 pm

Sorry, I thought you were saying you were having trouble trying to get lots of data that way.

You definitely want Auto Import while playing. The hands should be importing as fast as they're being written, so please restart PT3 with the Logging Enabled link, reproduce this problem as safely as you can, and report it so that we can look into what is going on here. I've never heard of auto import not being able to keep up with live play before, so we'll need to see what's actually going on in your system in order to figure out what to do next.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 5 guests

cron