APerfect10 wrote:rjbrown1965 wrote:I also expected the cluster, analyse and vacuum to take a bit quicker than in the previous release, the cluster has been running for over an hour and a half now and it's still going...........and going........and going....
There is no way to speed this up. This is a PostgreSQL process which will be the same regardless if you were using PT3 or any other software that is using a PostgreSQL database.
That's not entirely true. It is possible to tweak the PostgreSQL configuration for things such as buffers an such. Unfortunately I know to little about PostgreSQL myself so I can't give any advices. I am pretty sure there are several very people here that has the needed knowledge that maybe can write a guide for us.
Tweaking can have a very big impact on the performance.
If someone does, please put in considerations based on the users computer when it comes to such things such as CPU (number of cores for example), available RAM, but also if PostgreSQL is only used for PokerTracker or not.