Open Side Menu Go to the Top
Register
Calculating Database size Calculating Database size

07-25-2009 , 09:20 AM
I am interested in getting a separate HD in order to improve PT's performance.

I was wondering if anyone knew how many hands corresponded to 1GB or some other measure. Right now I have about 500,000 hands and I look to be adding around 100,000 hands a month. What would be a good HD size for me?

Also:

Is there a file I can look up at the postgresql directory?

If I were to install a new drive, I would need to backup my database, unininstall postgresql, copy the database to the new drive and reinstall postgresql correct?

Thanks

PS. Does the PT3 team have any problem with solid state disks?
07-25-2009 , 10:46 AM
I think the rough guideline is about 1GB / 100k hands, although that's from memory.
There is no single file that holds your database - if you start PT3 Build 5 (or 5.1) with logging from the new Start menu "with logging" option the database size in MB is written to the PokerTracker.log file (in the main PT3 folder).

There are links in the How To section of the Database / Postgres FAQ with a few different options for how to put your databases on a separate drive.
I haven't done any of these personally but it seems like the link in "How do I move my database to another drive?" could be your best option - it refers to removable drives, but the same should apply to another internal drive.
07-25-2009 , 12:17 PM
Thanks.
Quote:
I think the rough guideline is about 1GB / 100k hands, although that's from memory.
Are you sure about this? I thought it would be higher than that. If that's the case, an 80 GB drive would be more than enough for more than a year.

Quote:
There are links in the How To section of the Database / Postgres FAQ with a few different options for how to put your databases on a separate drive.
I haven't done any of these personally but it seems like the link in "How do I move my database to another drive?" could be your best option - it refers to removable drives, but the same should apply to another internal drive.
Thanks, that's what I was looking for.
07-25-2009 , 12:20 PM
I can't remember for sure - Kraada worked out the figures and he's on holiday at the moment. You can find the size of your database by looking in the log file as I desribed - if you can't find the information you can attach your log file to a support ticket and we'll find it for you.
Tutorial: Submitting a Bug Report
07-25-2009 , 01:44 PM
Quote:
Originally Posted by WhiteRider
I can't remember for sure - Kraada worked out the figures and he's on holiday at the moment. You can find the size of your database by looking in the log file as I desribed - if you can't find the information you can attach your log file to a support ticket and we'll find it for you.
Tutorial: Submitting a Bug Report
Ok, I looked it up. This is it right?
Quote:
2009/07/25 12:23:29.265: [- Main -][WindowMain] Database: PokerTracker 3 Database Size: 6178 MB
It's 6Gb. Cool.
07-25-2009 , 02:28 PM
Yes, that's right.
07-25-2009 , 03:14 PM
Do they have a problem with solid state disk???? Yes yes yes the seek times are way to fast. DB apps need to be slowed down by the disk system
07-25-2009 , 03:22 PM
Sorry - I forgot to reply about the solid state disk thing. I'm not aware of any problems, but I don't know of any testing either. I don't see why they shouldn't work, though.
07-25-2009 , 03:34 PM
Quote:
Originally Posted by vig
Do they have a problem with solid state disk???? Yes yes yes the seek times are way to fast. DB apps need to be slowed down by the disk system
Does this mean it makes them not worth buying or that I should expect a tad less performance but still an upgrade over a regular HD?
07-26-2009 , 01:59 AM
Quote:
Originally Posted by leviathan74
Does this mean it makes them not worth buying or that I should expect a tad less performance but still an upgrade over a regular HD?
If you have the cash buy the solid state disk. The performance should be a good improvement to poker tracker. DB apps like poker tracker need fast disk. SSD read times are much faster then traditional spinning disk. Enjoy
07-26-2009 , 02:06 AM
Quote:
Originally Posted by vig
Do they have a problem with solid state disk???? Yes yes yes the seek times are way to fast. DB apps need to be slowed down by the disk system
Sorry this was geek sarcasm. Fast disk = fast DB app

      
m