Very slow housekeeping

[markotm]

Hi,

I have wondered this same thing before but is this really normal - nothing I can do to speed things up?? I manually imported 1 million hands (bought from PTR, 1000 hand files) and after that the housekeeping is really slow. Vacuuming and analyzing took about 20 minutes which is ok but now the cache update / rebuild has taken about 1 hour 15 minutes and the time bar tells that it has done approximately 10% of the task so it seems that it will take a whole day and then some...

The manual import was not so quick either, it started ok with about 150 h/s but slowed really a lot towards the end, so much that I stopped and restarted the import which helped.

My PT3 is 3.11.11 and the PostgreSQL seems to be 9.0

[kraada]

That doesn't sound abnormal - one thing to keep in mind is that, due to the way we do the progress bar, the first few percentage points are statistically likely to take longer than the last few as it's based on the percentage of players left to cache and the players who are in the database in the beginning are more likely to have more hands and thus take longer to cache.

When this completes though you may want to look at the Performace Tuning: PostgreSQL tutorial as that may help you get improved performance in the future.

[markotm]

Now it has been over 7 hours and the progress bar is not even half way... since this and the manual import are so very slow I have decided to give up and buy an SSD drive. Can You give me instructions how to move all my PT3 related stuff from old HDD to new SSD?

[WhiteRider]

You can move all of your settings and data using the Backup/Restore mechanism.
However, you would get optimum database performance by having just the databases on the SSD rather than necessarily moving PT3 across too - there are a set of posts about the different options in the Database / PostgreSQL FAQ, and this thread has some tips about PostgreSQL optimization too.