Imported 1.5 Million hands.. REALLY slow..

[kraada]

PT3 can interact with PostgreSQL - you were able to import hands into your database. You can be 100% certain that the ODBC driver is installed and functioning, otherwise that would not work. The stack builder really doesn't matter for much else, so I really would not worry about it.

[genemish]

alright, that closes that "stupid question"...

currently at 11h:36m of clustering.. when done, i'll create a new test DB and run import into the night to compare..

[genemish]

clustering at 16hh:10m..

so if i am having issues during the read/write process.. can be it some sort of HD settings? some windows indexing crap?? something in the BIOS?

[genemish]

is this same/similar problems?

http://www.pokertracker.com/forums/viewtopic.php?f=16&t=21508&p=102566&hilit=HD#p102566

http://www.pokertracker.com/forums/viewtopic.php?f=16&t=23004&hilit=clustering&start=10

http://www.pokertracker.com/forums/viewtopic.php?f=16&t=21329&p=111735#p111735

and i found various other threads where housekeeping, specifically clustering, was taking a reallly long time.. what was the solution?

[genemish]

housekeeping at 17h:25m...

we are now updating cache -- postgre.exe is going crazy..

so my problem is with clustering and clustering only.

[genemish]

19hours total for housekeeping..

creating 2nd DB and will start again in a few..

[genemish]

2nd DB is up.. import started.. updates in 6 hours

[WhiteRider]

The main causes of slow clustering are not having enough free space on your hard disk for [postgres to make] a complete copy of your database, or the disk being really fragmented.
Database Management & Maintenance Guide

I guess you've already had all these links, but just in case:
Performance Tuning: Hard Drives
Performance Tuning PostgreSQL

[kraada]

So how did things end up after the new database import?

[genemish]

funny u asked, i checked this morning and wonderful windows 7 rebooted due to updates.. i forgot to check those auto-reboot settings.. so i started again about 2 hours ago..