Long story short, I had to abandon PT4 and use PT3 to reimport all my hands there, and then purge all my observed hands to make the db smaller (from 9mill to 1mill). This all went fine for a while, but now as there are about 1 mill observed hands left everything is soo slow. Estimated time to purge about 300k observed hands is now around 240 hours, this took 15 mins some days ago. I've run vacuum, analyze and update cache a couple of times with variable success, as this is also extremely slow and PT sometimes lose access to the db while housekeeping. Any advice?
Thanks
