delete some files from postgreSQL
Results 1 to 2 of 2
  1. #1
    Member
    Join Date
    May 2013
    Posts
    48

    Default delete some files from postgreSQL

    hi,
    Can I safely delete some big files from C:\postgreSQL\data\base?
    HM2 tells me this folder needs some space..
    I've got some files there called something like 413934.4 and they're over 1gb each.

  2. #2
    HM Support sideshow's Avatar
    Join Date
    Aug 2011
    Posts
    2,605

    Default

    Hi,

    No this is not possible as this is your database, Some SSD's now use compression automatically. The Truth About SSDs and Compression

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

    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

    Please see this guide to optimize your SSD:

    Can You Get More Space Or Speed From Your SSD? - Optimizing Precious Solid-State Storage

    Here is another guide:

    http://itexpertvoice.com/home/super-...at-them-right/


    Here is our FAQ to transfer to another database:

    http://faq.holdemmanager.com/questio...e+or+Partition
    ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, you can do so here: Leave Feedback

Similar Threads

  1. I'd like to delete these 1.11TB of files...
    By TimM846 in forum General Support
    Replies: 12
    Last Post: 11-10-2014, 12:10 PM
  2. Delete files in C:\Program\PostgreSQL\8.4\data\base ?
    By glennis in forum Manager General
    Replies: 3
    Last Post: 07-12-2013, 01:06 PM
  3. is it safe to delete log files?
    By bacanef in forum Manager General
    Replies: 1
    Last Post: 04-25-2010, 05:04 PM
  4. HM Processed files- delete?
    By Boots23 in forum Manager General
    Replies: 5
    Last Post: 01-05-2010, 09:02 PM
  5. Safe to delete these files???
    By TheMonkMan in forum Manager General
    Replies: 3
    Last Post: 09-28-2008, 09:43 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •