problem importing hands/wrong stats

[PumaPerez]

hi,

looks like my database have problem to load hands from hand history folder of pokerstars. also some stats are wrong shown in graphs and results. i tried revert database tuning, restart computer, everything i was able to find, but none of that works.
looks like it is importing 1 hand every 3 seconds. log attached.
also there was imposible to start vaacum&analyze feature till today to get rid of duplicates, which are very common loaded, dont know why. after this feature was started there was always error message about not enough memory or something like that. PT4 log stated i have 4GB physical RAM, but i have 12GB which i can normally see in OS, also have enough free space on harddisk. i cant reproduce this right now, because i cant stop importing hands feature, it doesnt react and still importing like 1 hand in few seconds...

all started after .18 update i think.

log: http://dl.dropbox.com/u/22640474/PokerTracker4.log

[WhiteRider]

Please read this tutorial which should sort out your 'duplicates' issue. Once you've done that, if you still have problems please attach the new log file to a Support Ticket - that makes it much easier to keep track of in our system and pass on to the development team if needed.

[PumaPerez]

hi,

thanks for help. i moved all HH to processed folder manualy, so i hope things gonna be ok in future.
anyway i reproduced the vacuum&analyze error.

[ img ]

[WhiteRider]

I believe that can be caused by slightly over-done PostgreSQL tuning settings on some systems. These settings have been changed for the next release, but for now please try reverting the PostgreSQL tuning via the Database > Database Management > Housekeeping, and that should allow you to vacuum & analyze.