PT2 imports hands extemely slowly

[cool32steve]

I converted my database to PostgreSQL, and since the hands import extremely slowly. I found a file with only one hand in it, and it took 17 minutes to import. What can I do?

[ptrack pat]

Use the Utilities > PostgreSQL Database Functions window to do a full vacuum/analyze.

[cool32steve]

I will try this, thanks!

[cool32steve]

I tried 2 full vacuum/analyze, and it still takes over 1 hour to import 100 hands. Anything else I can try?

[ptrack pat]

Are you sure the "Auto-rate on import" box is not checked when you try to import hands? If it's not then it sounds like their is an index problem in that the database didn't fully convert so you should try converting the Access database again and make sure that you check the status after it's done to make sure it converted without errors.

[cool32steve]

Uh-oh... The first thing I tried to correct this issue was to delete the old database, thinking that there may be some conflict... Oh well, at least I have all my hand histories saved on CD... Thanks as always for the support!