PDA

View Full Version : PostgresSQL dbase compression



Ryan Donk
04-07-2009, 04:38 AM
Hi there,

I'm using HEM on my 5 year old laptop running WIndows XP. It's working fine, but my laptop is getting slow since the 60GB hard drive is almost full. While trying to delete stuff, I noticed that the PostgresSQL dbase folder HEM uses takes up about 8GB of disk space, which seems a lot for about 200k hands.

I went through the manual vacuum analyze option in postgresSQL (HEM vacuum option didn't work) but this only cleared up about 200MB of space. Is there any way to compress this huge postgres dbase?

Thanks!

morny
04-07-2009, 01:44 PM
See this thread http://www.holdemmanager.net/forum/showthread.php?p=32648#post32648

Also have a look in this folder C:\Program Files\PostgreSQL\8.3\data\pg_log

Everything in there can be deleted and theres usually a huge amount of logs