Pokertracker/postgres/600000 hands --- 2GB or 4GB RAM?

flite · #1 10-22-2007, 06:17 AM

I'm actually buying a new computer and since 2GB RAM cost less than the average visit at Burger King, my question is: 2GB or 4GB?

The computer mainly hosts poker software and a 600000 hand postgres database. do you think 4gb would make it run faster?

beside of that: does raid0 make PT/postgres faster?

thanks and cheers.

nuclear500 · #2 10-22-2007, 09:44 AM

You want to avoid RAID 0 unless you're backing [censored] up constantly. The day one of the drives fails in a RAID 0 is the day you realize you've made no backups and have just lost everything permanently.

To answer your questions though: yes and yes.

Josem · #3 10-22-2007, 10:00 AM

1) just get 2gb ram.

2) i've checked three times your question about the number of hands, and i'm confident that you left out a 0 or two. 600,000 hands is not going to be much of a challenge on ram.

until this week, i was running 1gb of ram, and i have a PT database of around 2.4million hands. I actually have over 600k hands from October alone.

i just got another gb of ram (making it 2gb now), and dont notice any PT performance improvements.

processor speed will make a bigger difference, methinks.

allyasia · #4 10-22-2007, 11:24 AM

[ QUOTE ]
1) just get 2gb ram.

2) i've checked three times your question about the number of hands, and i'm confident that you left out a 0 or two. 600,000 hands is not going to be much of a challenge on ram.

until this week, i was running 1gb of ram, and i have a PT database of around 2.4million hands. I actually have over 600k hands from October alone.

i just got another gb of ram (making it 2gb now), and dont notice any PT performance improvements.

processor speed will make a bigger difference, methinks.

[/ QUOTE ]
Oct is not even over yet
how do F did you get so much hand?
how many table did you play? for how man HR?
i am more interest to know, how much RB did you make^^

funkyworms · #5 10-22-2007, 11:30 AM

I'm going to go out on a limb and say that he didn't play 600k hands this month - he datamines.

Bremen · #6 10-22-2007, 03:03 PM

If you are running windows 4GB is only worth it if you're running 64bit. (32 bit windows will only let you use 3GB) You'll get a much better return going for a dualcore processor (or quad core *drool*) since Postgres is multithreaded.

flite · #7 10-23-2007, 01:34 PM

i have a dualcore 2.66 ghz on my list.
do you think changing to quadcore 2.4 ghz would make a huge difference? (price is only 80 bucks more)

Duke · #8 10-23-2007, 04:45 PM

I've always been curious if you can host the postgres db on its own machine and connect to that with tracker. Then you can just do a 64 bit linux install and be ready to rumble for a while.

I don't play poker anymore, so I don't even really need an answer. It just seems like that might be a decent solution.

Josem · #9 10-23-2007, 06:54 PM

[ QUOTE ]
I've always been curious if you can host the postgres db on its own machine and connect to that with tracker. Then you can just do a 64 bit linux install and be ready to rumble for a while.

[/ QUOTE ]

yeah, there's no reason you can't connect PT to a postgres database on another machine - either across a LAN or a WAN. of course, speed would be lessened...

Bremen · #10 10-23-2007, 07:20 PM

[ QUOTE ]
I've always been curious if you can host the postgres db on its own machine and connect to that with tracker. Then you can just do a 64 bit linux install and be ready to rumble for a while.

I don't play poker anymore, so I don't even really need an answer. It just seems like that might be a decent solution.

[/ QUOTE ]

I do this. Mostly because postgres would seriously lag my system during imports. It still pegs the proc on my linux machine however this doesn't cause me to timeout of a hand so its all good.