Jun
04-07-2010, 04:15 AM
hi, support
i had a huge database on my desktop so i decide to clean it up recently. those are what i did.
i went to option>purge hands and choose to purge old observed hands from my database completely except those who played by hero which is obviously myself.
then i tried to vacuum database from hm and got a complain. so instead, i went to pgadmin and did a complete vacuum+index there.
as i watched from purging, i purged more than 20million hands from my database. but after the vacuum, i didn't see any space freed up. i thought defragment my disk will help. but it didn't either.
so how do i free up those spaces, it should be around 20g of disk space.
The other question is that how do i get rid of those old observed hands from the stats that showing in my hud. I am seeing alot of players in my game with a stats of over millions hands which included alot of hands years ago. I would like to not include those outdated data into my hud displaying since those data are actually misleading to me.
thanks
-Jun
i had a huge database on my desktop so i decide to clean it up recently. those are what i did.
i went to option>purge hands and choose to purge old observed hands from my database completely except those who played by hero which is obviously myself.
then i tried to vacuum database from hm and got a complain. so instead, i went to pgadmin and did a complete vacuum+index there.
as i watched from purging, i purged more than 20million hands from my database. but after the vacuum, i didn't see any space freed up. i thought defragment my disk will help. but it didn't either.
so how do i free up those spaces, it should be around 20g of disk space.
The other question is that how do i get rid of those old observed hands from the stats that showing in my hud. I am seeing alot of players in my game with a stats of over millions hands which included alot of hands years ago. I would like to not include those outdated data into my hud displaying since those data are actually misleading to me.
thanks
-Jun