PDA

View Full Version : Delete files in C:\Program\PostgreSQL\8.4\data\base ?



glennis
07-11-2013, 09:08 AM
Hi

Is it possible to delete the files in that directory? It currently takes up 24 gig for me and thats pretty damn huge. And if I shouldnt delete them can I zip them or move them do the D disk instead?

I will import another ~5M hands so it's gonna get a lot bigger as well and im running out of memory on the C disk

udbrky
07-11-2013, 06:10 PM
Absolutely not. That is your database.

Out of HM1, HM2, PT3, HM2 has by far the smallest DB's.

Some SSD's now use compression automatically. The Truth About SSDs and Compression (http://rscott.org/ssd/SSDs_and_compression.htm)

You can also use NTFS compression on the DB folder in roaming and the postgres\data\base folder to make it smaller:

Best practices for NTFS compression in Windows (http://support.microsoft.com/kb/251186)

You can put your postgres data folder and the HM2 database parent folder on a different drive.

In HM1 there are a lot of tables that deal with a specific hand played by a specific player. In HM2 we don't have these tables, instead, for player related hand data, we use a flat file approach. Each player has his own folder and each file represents a single day. Each line within the file is a tokenized version of a single hand with incredible amounts of detail. Your overall HM2 spaced used (DB + Files) is about 2/3 of HM1 and we store probably 2-3 times as much info plus it can be accessed many, many times faster and allows us to do some things that wouldn't be possible otherwise, many of which are yet to come. If you don't want the space in your Roaming folder due to C: file space or something like that, we do give you the option of storing this data anywhere

General rule is 1 million hands = 10 GB.

In reality it's: 1 million hands
HM1: 6.8 GB
HM2: 4.3 GB
PT4: 13.6 GB

So with a 10 million hand database you need as SSD of at least 60 GB (Windows) + 100 GB = 160 GB.
We use 1 million = 10 GB (instead of 6.8) because when you want to perform a vacuum/analyse or backup/restore a database it will require a LOT of disk space to perform such a task.

You can also run tree size free to locate wastes of space:

TreeSize Free - Quickly Scan Directory Sizes and Find Space Hogs (http://www.jam-software.com/treesize_free/)

Please see this guide to optimize your SSD:

Can You Get More Space Or Speed From Your SSD? - Optimizing Precious Solid-State Storage (http://www.tomshardware.com/reviews/ssd-performance-tweak,2911.html)

Here is another guide:

Super-Fast SSDs: Four Rules for How To Treat Them Right « IT Expert Voice (http://itexpertvoice.com/home/super-fast-ssds-four-rules-for-how-to-treat-them-right/)


Here is our FAQ to transfer to another database:

http://faq.holdemmanager.com/questions/368/Move+Database+to+Another+Hard+Drive+or+Partition

glennis
07-12-2013, 08:24 AM
You can put your postgres data folder and the HM2 database parent folder on a different drive.


Ok, thanks for your response.

How do I do this? just move the folder and it will save on D from then on?

udbrky
07-12-2013, 01:06 PM
See the FAQ at the end of my post.