Acme
10-30-2008, 06:36 AM
Hi.
I have recently removed my system to Windows Vista. I did remove my DBs by the use of hands export / import, installed SQL 8.3 and the latest HEM beta for Party. But it turned out that all not mine HHs in my DB were with showdowns only, which results in unrelistic high WentToSD for my opponents. So I purged every sinlge hand from the base, except for mine, and then renew the database from other sources, so now displayed stats in HEM are OK. But the strange thing is that HUD still displays wrong WentToSD (Winrate and stuff) for some of players :eek: I haven't found anything related to that in FAQ.
And the other question I'd like to ask is how to vacuum DB through pgAdmin (HEM refused it with a mistake). I press OK in "Maintaince" menu (vacuum and analyze are checked), but it seems like nothing is performed. I only see the list of messages like "INFO: "tables": scanned 2 of 2 pages, containing 299 live rows and 0 dead rows; 299 rows in sample, 299 estimated total rows" and so on, finally the "Finish" button gets active. It looks like it is not need to vacuum DB, but I removed a ton of hands from it, and it was HEM's suggestion to perform vacuum / analyze.
I appreciate any help.
I have recently removed my system to Windows Vista. I did remove my DBs by the use of hands export / import, installed SQL 8.3 and the latest HEM beta for Party. But it turned out that all not mine HHs in my DB were with showdowns only, which results in unrelistic high WentToSD for my opponents. So I purged every sinlge hand from the base, except for mine, and then renew the database from other sources, so now displayed stats in HEM are OK. But the strange thing is that HUD still displays wrong WentToSD (Winrate and stuff) for some of players :eek: I haven't found anything related to that in FAQ.
And the other question I'd like to ask is how to vacuum DB through pgAdmin (HEM refused it with a mistake). I press OK in "Maintaince" menu (vacuum and analyze are checked), but it seems like nothing is performed. I only see the list of messages like "INFO: "tables": scanned 2 of 2 pages, containing 299 live rows and 0 dead rows; 299 rows in sample, 299 estimated total rows" and so on, finally the "Finish" button gets active. It looks like it is not need to vacuum DB, but I removed a ton of hands from it, and it was HEM's suggestion to perform vacuum / analyze.
I appreciate any help.