There is no space in my C: disk
Results 1 to 2 of 2
  1. #1
    Junior Member
    Join Date
    Nov 2009
    Posts
    4

    Default There is no space in my C: disk

    Hello all:
    I bought HH, but after few days importing, I found that my C: disk is fulled of data. I can not import HH anymore. Could you please tell me how to solve this problem? Thank you very much!!

  2. #2
    *** HM3! *** fozzy71's Avatar
    Join Date
    Sep 1971
    Location
    HM Support
    Posts
    29,829

    Default

    Try and delete and unnecessary media files, like movies/tv, etc, as they take a lot of space. I use windirstat to find the files taking the most space on my machine.


    Logging:

    I would suggest you turn off logging on your new SQL installation as well as these other performance improvements in my signature - Top 10: HEM performance increase tips


    To turn off logging, follow these instructions. This is the first thing I do anytime I install SQL for someone.

    - Start > My Computer > Tools > Folder Options > View > UnCheck 'Hide Extensions for known file types' > OK

    - C:\Program Files\PostgreSQL\data\postgresql.conf > Right-Click > Open With.. > NotePad > Check 'Always use this program'

    - Scroll about half way down to ~Lines 245 - 260:

    - The last line of this block of code, for the 'logging_collector', must be changed from On to Off.


    HTML Code:
    ------------------------------------------------------------------------------
    # ERROR REPORTING AND LOGGING
    #------------------------------------------------------------------------------
    
    # - Where to Log -
    
    log_destination = 'stderr'        # Valid values are combinations of
                        # stderr, csvlog, syslog and eventlog,
                        # depending on platform.  csvlog
                        # requires logging_collector to be on.
    
    # This is used when logging to stderr:
    logging_collector = off        # Enable capturing of stderr and csvlog

    File > Save; File > Close

    Start > Programs > PostgreSQL 8.3 > Reload Configuration.


    - Start > My Computer > C:\Program Files\PostgreSQL\data\pg_log, or C:\Program Files (x86)\PostgreSQL\data\pg_log, if you have 64 bit Vista. Delete all files in that folder. And it might be a good idea to empty your recycle bin at that point, or use a 3rd party utility like CCleaner to clean up all your junk/temporary files. You want to do this before you get to the vacuum and defrag process.



    Regarding database maintenance:

    You should regularly purge mined hands in your database, after purge vacuum / full analyze the database via pgadmin. You do not want to purge any Hero hands so make sure your alias is properly configured before purging.
    FAQ - Hold'em Manager Poker Tracking Software :: Purge Hands from Database
    FAQ - Hold'em Manager Poker Tracking Software :: Purge Hands

    Then you can vacuum/analyze - FAQ - Hold'em Manager Poker Tracking Software :: Vacuum Analyze Database

    Before you defragment you should stop the PostgreSQL service:

    Start > Programs > PostgreSQL 8.x > Stop Server

    Use your favorite defrag tool. I recommend Smart Defrag.

    After defrag I recommend you reboot your PC. If you need to access the DB before rebooting you can start the PostgreSQL service.

    Start > Programs > PostgreSQL 8.x > Start Server

Similar Threads

  1. How to get more disk space?
    By Selo in forum Manager General
    Replies: 5
    Last Post: 10-07-2010, 01:31 PM
  2. low disk space ... now what??
    By zgpwns in forum Manager General
    Replies: 13
    Last Post: 02-14-2010, 10:56 AM
  3. Freeing disk space
    By nosmith in forum Manager General
    Replies: 3
    Last Post: 12-22-2009, 06:02 PM
  4. Freeing up Disk Space
    By nosmith in forum Manager General
    Replies: 1
    Last Post: 09-29-2009, 09:28 AM
  5. Disk Space not returning
    By Luca2903 in forum Manager General
    Replies: 21
    Last Post: 12-31-2008, 08:32 PM

Posting Permissions

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