Housekeeping Freeze?

[pr1mo]

I did a very large first import of 20+million hands and I started it a few days ago and i've never had this before but the time stopped counting up at 17:54:27. The 5 bars are still scrolling across the progress area but the clock has been frozen for over a day now. Have you guys encountered this before? Do you know if the housekeeping is still performing? Or should i restart the housekeeping? I heard before that it is not good to stop pt3 in the middle of housekeeping. I have PokerTracker.exe running at Mem Usage of 196,348k still in task manager processes I have pt3 in processes doing a housekeeping on another computer and it is showing PokerTracker.exe running at 363,892k

[WhiteRider]

So the hands are all already imported, and housekeeping has started?
Which part of housekeeping is currently active?

Have a look at the postgres.exe processes in Task Manager - if any of those are working hard then housekeeping is still going; the housekeeping work is actually done in Postgres not PT3.

[pr1mo]

It says it's at 17h 54m 27s and says it's Clustering still but I started this housekeeping 3 days ago so it's either at the end of Clustering right now or at the beginning of Updating Cache. I can't tell because the time total isn't updating anymore but the 5 bars is still going across the screen.

20+m hands are imported. Postgres is running in the task manager and a bunch of them and it looks exact same as one of my other comps that's running a housekeeping right now.

[kraada]

How much free space do you have on the hard drive in question?

[pr1mo]

It's a 1TB drive with 258mb free. Only thing on it is pt3+postgres data folder. main postgres install is on c: i have 2 db on the drive. one is 323gb and the other is 301gb. The 301gb is the one that's running right now and i see inside the folder that files are updated as of this minute inside that postgres folder. So it looks like it is running. It's just that the time isn't counting up anymore and still frozen at Clustering: 17:54:27

[kraada]

You mean 258G free? With a 301G database being clustered it's going to take longer than normal given that 258G < 301G. So PostgreSQL has to take a longer route towards clustering. It will still finish, just take longer. That's also quite a lot of data, so I wouldn't expect it to finish quickly . . .

[pr1mo]

Yes I meant 258gb. I'm not worried about the speed. Just wanted to make sure that it was still going to be ok and finish ok even tho the time has frozen stopped at 17:54:27 but the 5 bars are still moving across the screen and files in data\base folder are still time stamp updating every minute.

[newbiE]

I've imported 5 million hands on my homecomputer and housekeeping is running for 63hours(!!) now. you guys think it is still ok?

[kraada]

pr1mo,

Things are definitely still working then, just be patient and things will eventually finish. Clustering is a pretty intensive function and the first time a database is clustered it's going to take longer than subsequent clusterings.

newbiE,

How much free space do you have on the drive in question, and is it still clustering or has it moved on to other housekeeping functions?

[newbiE]

Postgres folder itself is about 45 GB big and i have 21 GB left on that drive Postgres is installed on. I know i need at least 45 GB left for propper speed, i will change that later. Although it is slower due to limit space it shouldn't take 65h? It is still clustering btw.

Looking at the taskmanager i see my computer is only working with like 5% capacity. You think i should restart housekeeping?