PostgreSQL 8.4, is it possible to install this with PT3?

[Juhaboy1980]

Is it possible to install PostgreSQL 8.4 after using pokertracker 3 and PostgreSQL 8.3 for a while?

If it is possible, could someone please tell me how this is done?

And if someone has good performance tips for PostgreSQL 8.4 ( or 8.3 ) please tell me =)

Someone should publish full guide how to optimize PostgreSQL for Pokertracker 3 with different hardware
and different sized databases. I for that matter have huge database and I7 965, 8gb 2000mhz, and 6 x 1tb in raid 5.
I should have fast Pokertracker experience, but no, the database is too huge and I dont have the skills to optimize PostgreSQL.

So please help me my fellow trackers!

[kraada]

With regards to optimizing there is the Performance Tuning: PostgreSQL thread which goes through some performance tuning options.

For migrating from 8.3 to 8.4 you have a couple of options:

(NOTE: Before starting any migration of this magnitude, I STRONGLY suggest backing up your databases; there's a good tool for this in Beta 30.1, so it should make things much easier now than it was previously.)

(1) There's a migration tool available here which is reputed to work well. I haven't tried it personally, though, so I can't say from firsthand experience.
(2) Backup your databases, uninstall PostgreSQL 8.3, install PostgreSQL 8.4, restore your backups in 8.4. (This is basically the manual version of what the migration tool should be doing; the migration tool probably makes it easier though.) Once you have 8.4 installed and working you can then delete your 8.3 data directory.

[Brainish]

Are there any plans to package a newer version of PostgreSQL with Poker Tracker?

[cristof78]

i can not download postgresql i dont know wy?"The webpage cannot be found "
can somebody help me?
thank you

[WhiteRider]

Are there any plans to package a newer version of PostgreSQL with Poker Tracker?

Yes, the PostgreSQL version included with PT3 will be updated, but I don't know when.

i can not download postgresql i dont know wy?"The webpage cannot be found "
can somebody help me?
thank you

I just tried the download and it worked fine for me - maybe you can try a different browser?
What webpage can't it find?

[zubs1aa]

running 8.3 now.

If i move to 8.4, should there be any fundamental performance increases? (Never know if an update is just,,,, well an update......)

[kraada]

I've been looking into it a little bit; there have been some improvements which if you have large databases should result in faster CLUSTER times. Exactly how much I'm not sure though; basically it's changed so that PostgreSQL auto-tunes to your system's specifications, rather than using the old defaults which can slow things down significantly depending your hardware.

If you're looking at having databases with cluster times of 10+ hours, it might be something to look into. That seems to be the biggest benefit for our purposes that I've been able to glean so far.

[zubs1aa]

I've been looking into it a little bit; there have been some improvements which if you have large databases should result in faster CLUSTER times. Exactly how much I'm not sure though; basically it's changed so that PostgreSQL auto-tunes to your system's specifications, rather than using the old defaults which can slow things down significantly depending your hardware.

If you're looking at having databases with cluster times of 10+ hours, it might be something to look into. That seems to be the biggest benefit for our purposes that I've been able to glean so far.

auto-tunes? so 8.4 will tune to my system without me doing anything? As opposed to running the app stack builder process manually?

If so, that's a sweet addition and you ought to put EVERYONE on 8.4 and have a ton more people tuned up that aren't going to geek out in the forums...

[kraada]

Not everything, but the free space map was rewritten so that max_fsm_pages and max_fsm_relations are no longer used. See here for more details. It doesn't autotune everything, unfortunately, but it's definitely an improvement.

[zubs1aa]

Not everything, but the free space map was rewritten so that max_fsm_pages and max_fsm_relations are no longer used. See here for more details. It doesn't autotune everything, unfortunately, but it's definitely an improvement.

OK- that was a bit over my head lol. I'll asume it means it's better tho

Let me ask this. I did the perf. tune with the stack builder for 8.l3 when i installed.

Now that the db has changed due to upgrades to PT and my db is also much bigger, is it worth running the 8.3 auotune again? Or will it get same results since my physical system didn't change?

Thanks