purging time

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

purging time

Postby redcow » Fri Nov 07, 2008 5:34 pm

Hi,

Im purging ~80% of a 5 mio. PT3 Databases and it is now over 3h, (Core 2Duo T7500, 2.2ghz, 2gb ram) I thought purging would be much faster than any other operation (cluster, analyze..) is there some estimate how long it would probably take?
redcow
 
Posts: 28
Joined: Sat Jan 26, 2008 8:15 am

Re: purging time

Postby kraada » Fri Nov 07, 2008 6:35 pm

Are you using Beta 20 or Build 3? Beta 20 should have some speed improvements in purging. Unfortunately, at the moment I don't know of a way to check to see how long the purge is going to take, sorry.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: purging time

Postby Eric Poker » Fri Nov 07, 2008 9:08 pm

kraada wrote:Are you using Beta 20 or Build 3? Beta 20 should have some speed improvements in purging. Unfortunately, at the moment I don't know of a way to check to see how long the purge is going to take, sorry.


Build 3 doesnt have a selective purge function
Eric Poker
 
Posts: 104
Joined: Sat Mar 15, 2008 3:47 pm

Re: purging time

Postby redcow » Sat Nov 08, 2008 7:34 am

yes Beta 20 now its over 16h, the estimated time to end shows only random numbers therefore useless, would enabled logging allow me to get an estimation about how long it would take?
redcow
 
Posts: 28
Joined: Sat Jan 26, 2008 8:15 am

Re: purging time

Postby kraada » Sat Nov 08, 2008 10:02 am

You raise a good point, Eric :)

I believe logging enabled would give you some information in the log file but I'm not 100% sure how much. Either way you'd have to restart PokerTracker 3 for logging to begin so that wouldn't really help with the current spot you're in.

What are the "random numbers" it's giving you for time to completion?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: purging time

Postby redcow » Sat Nov 08, 2008 10:58 am

Elapsed time 20:00:50
Estimated time: 14760:41:36

therefore not really "random" numbers but unrealistic time. I'm not really sure what I should do, the hdd activity led is blinking and also the process manager shows PT3 working so it doesnt seem that something crashed but over 20h is really strange, doing analyze+cluster+update cache for all 3 databases took me 27 hours, so only purging should be considerable faster.
redcow
 
Posts: 28
Joined: Sat Jan 26, 2008 8:15 am

Re: purging time

Postby kraada » Sat Nov 08, 2008 11:05 am

I'm not sure what can happen from killing the purge process but I'll check for you; it really shouldn't take that long.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: purging time

Postby redcow » Sat Nov 08, 2008 3:18 pm

I killed the process and tried it again purging only 200-300k hands, don't know if it works, estimated time to end is again messed up, is there maybe a problem with the purging function in the new beta ? can someone confirm this ? or confirm that he purged more than 100k hands without a problem? unfortunately in the log files is nothing written during the purging process
redcow
 
Posts: 28
Joined: Sat Jan 26, 2008 8:15 am

Re: purging time

Postby APerfect10 » Sat Nov 08, 2008 9:32 pm

I can confirm that another user is having the same problem and submitted a log file.

If you could enable logging, purge then send us a second log file, I am sure that would greatly assist us in troubleshooting the issue.

Best regards,

Derek
APerfect10
Site Admin
 
Posts: 4465
Joined: Sat Dec 08, 2007 6:03 pm

Re: purging time

Postby redcow » Thu Nov 13, 2008 5:03 pm

Yeah did that few days ago, what are my options now ? Is there an older PT3 beta/stable version which used a different "purge code" or can I only wait for the next beta and pray a fix was found/included ?
redcow
 
Posts: 28
Joined: Sat Jan 26, 2008 8:15 am

Next

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 22 guests

cron
highfalutin