PDA

View Full Version : Backup & Restore has taken up a lot of memory on new PC



pellshek
05-26-2011, 07:32 PM
After doing my Backup/Restore process onto a rebuilt computer I noticed that my spare computer memory on my new PC went from 79GB down to 54GB (out of a total 93GB) after the process.

Does this sound right? It seems like a hell of a lot to me even allowing for HEM and SQL being loaded onto the machine during the process. I don't think HEM took up that much on my last computer, so I'm thinking some large amount of info/hands/whatever has be transferred that I usually keep on my external disc, but I can't seem to find any such info/hands/whatever anywhere!

BTW, my DB would have been large, 1m+ hands I think.

Also slightly odd is when I look at the size of SQL. In Control Panel>Programs, SQL is listed as 108GB (??), but when I look at it in SQL > Properties it's 60 KB.

Ugh, really confused.


Thanks.

Patvs
05-26-2011, 08:41 PM
1 million hands take about 10 GB of space.

Go into your PostgreSQL/8.x/data/pg_log folder
and delete ALL the files in that folder.


---


Read:
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html

pellshek
05-27-2011, 05:15 AM
Hi Pat,

Thanks for your quick reply.

Unfortunately, that folder only contained 1 file and removing it made little or no difference. (I had that "pg-log" feature turned off on my last computer so perhaps there weren't that many files to transfer).

Any other ideas?

Patvs
05-27-2011, 07:32 AM
How large in your entire PostgreSQL/8.4/data folder (of you right click on the properties of that folder) ?

What was the size of the .backup file?
If the file was 1 GB.... it should result in a 11-14 GB database.

If you've lost 22-28 GB of diskspace:
-1 read:
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html

(and VACUUM the database, run CCleaner, etc.)
-2 it's possible during the backup/restore process a file was created in your TEMP folder that was never deleted.
Check what the size is of your TEMP folder, default location for that is:
C:/User/Yourname/AppData/Local/

(this is a hidden folder: First of all, we need to enable the option to see Hidden Files: How to see hidden files in Windows (http://www.bleepingcomputer.com/tutorials/tutorial62.html)
http://rvgsoftware.fileburst.com/images/hidden.jpg

pellshek
05-27-2011, 08:47 AM
Thanks Pat,

I did a Vacuum and Reindex on my old machine just before doing the Restore/Backup, but I'll try that again if you don't spot any other problems below.

On the file sizes (after doing the "Show hidden files" procedure you mention):

> Temp = 12 GB
> SQL Data folder = 9.2 GB
> Backup file (the .hembk one) = 727 MB

Patvs
05-27-2011, 09:05 AM
You can delete the 12 GB file in the temp folder.

pellshek
05-27-2011, 09:14 AM
That's great Pat, many thanks - deleting stuff in that TEMP folder (except for the stuff it wouldn't let me delete!) released 12 GB, which when I think about it is probably about right.

Problem resolved. Thank you.