postgres tweaking for speed query

[MoniesRemovalPLC]

i came across the article about tweaking up postgres to speed up you PT3, heres the article... http://www.pokertracker.com/forums/viewtopic.php?f=45&t=10393 unfortunately i have an older version of postgres on my computer (version 8.2) and was wondering what it would mean to upgrade? does it mean losing my PT3 datatbase / HEM databases and reimporting all the hands? if it does then can i tweak my postgres 8.2 in a similar way to accomplish incresed performance

[kraada]

I cannot speak for HEM databases - you would need to talk to their people to find out what to do. However, if you use the PT3 backup function (for which a tutorial can be found here), then upgrade PostgreSQL, then restore that backup into the new version, it will work properly - and in fact it's the easiest way to go about making a major PostgreSQL upgrade. 8.3 will provide significant performance improvements over 8.2. 8.4 and 9.0 will provide further improvements as well - I'm personally running 9.0 at this point and haven't run into any problems with it and PT3. As far as what version to upgrade to . . . if you're going to go to the hassle of upgrading, you might as well go all the way to 9.0. If you were already on 8.3 rather than 8.2 the difference in performance would be a lot less noticeable and then it would be unclear whether or not it was worth the effort, but from 8.2 it will be significant.

[skinroy]

so if i am using version 8.3 i am ok?also do you recomend doin what is said in the link to speed up my system?

[kraada]

You'd see some improvement from upgrading, but I haven't run detailed analyses to see exactly how much. The ballpark numbers I'd imagine from the various things I've read online are in the 5-10% area, but it varies a lot depending on exactly what you're doing. You'll almost certainly get bigger results from doing the performance tuning - letting PostgreSQL use more RAM is going to be a lot more effective than any small improvements made from 8.3 to 8.4 and 9.0.

[skinroy]

just tried tweekin and enterprise tuning wizard is not under addons it is under registration-required add-ons and it is making me sign up at this site https://www.enterprisedb.com/user-login ... ype=tuning /should i?or am i doin it wrong already? :cry:

[WhiteRider]

I think you only need to register your details - you shouldn't have to pay anything.

[skinroy]

when tuning it gives 3 different options developement,mixed and dedicated,i know not to use dedicated,butt not sure to use development or mixed.i did the developement way and it didnt seem to actually do anything that i saw allthough i havent been able to play a session yet,just wanna make sure i did it correctly

edit no didnt have to pay nothing butt needed to enter in all my info including phone number

[kraada]

We actually recommend using Mixed for best performance when using the autotuner - though doing anything should likely still be an improvement over having done nothing.

[skinroy]

ty