huge postgreSQL file
Page 1 of 2 12 LastLast
Results 1 to 10 of 12
  1. #1
    Junior Member
    Join Date
    Jan 2009
    Posts
    28

    Default huge postgreSQL file

    the 8.3\data\base file is 9Gigs. I just reformatted my cpu this month...

    Previously, the file that gave me issues was the pg_log file. I followed your instructions to re-configure the postgresql.conf file, and since then I haven't had anymore large pg_log files.

    Is there any way I can decrease the size of the base file? Is that my database? What happens if I delete those files, will HEM still have hands on my opponents, myself etc.?

  2. #2
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    Don't delete anything in the data/base folder.
    That's your actual database.


    Read: http://forums.holdemmanager.com/mana...ease-tips.html

    #8,9, 11 to gain more diskspace/ make the database smaller
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    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 this here

  3. #3
    Senior Member
    Join Date
    May 2009
    Posts
    255

    Default did mine yesterday

    Just yesterday I looked at my Postgres directory and it was 38.5 GB so I went through the purge / vacuum / analyze process and when done it was down to 21.4 GB.

    I hadn't noticed any performance problem and when playing last night after doing the maintenance I didn't really see any difference. But it definitely knoced almost 20GB off my files.

  4. #4
    Junior Member
    Join Date
    Jan 2009
    Posts
    28

    Default

    yes I did the manual vacuum and re-indexed, but that only gave me an extra 1/2 a gig

  5. #5
    Tech Support Manager morny's Avatar
    Join Date
    Jul 2008
    Location
    Ireland
    Posts
    20,889

    Default

    Sometimes it needs a reboot to reclaim the extra space, try that, other than that the best way to shrink the database is exporting the hands, can you create a new database FAQ - Hold'em Manager Poker Tracking Software :: Create / Delete Database and reimporting the hands and then deleting the old database when your sure the new database has all the data

    If your doing this you should also consider the following.

    Export Your Notes


    Export Your Bonuses and Rakeback - Options > Rakeback & Bonuses

    Export any tourney summaries by selecting all your tournaments in the Data View Sub-Tab of the Tourney > Results Menu and choose Export Tourney Results and summaries

    --------------------------------------------------------------------------------------------------------------------
    We welcome any feedback on any solutions we provide, this helps us to provide better quality solutions in the future.

  6. #6
    Junior Member
    Join Date
    Jan 2009
    Posts
    28

    Default

    Thank you for the suggestion. I have rebooted my cpu since then, however the size of my db has not decreased.

    Regarding exporting and then reimporting, would the size of the DB not be the same after reimporting as it was before exporting?

  7. #7
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,708

    Default

    You need to create a new empty database to which you import the files.

    After completion and everything running well you can delete the old database.

    Btw: 20 GB is not that much for a database

  8. #8
    Junior Member
    Join Date
    Jan 2009
    Posts
    28

    Default

    Yes, I'm just curious as to how much the size of one's DB can be diminished through this process

  9. #9
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,708

    Default

    I would roughly calculate with 10 GB for 1M hands.

  10. #10
    Junior Member
    Join Date
    Feb 2009
    Posts
    5

    Default

    I have a big HM database (32 Gb), I purged 4 millions of old hands following
    FAQ - Hold'em Manager Poker Tracking Software :: Purge Hands
    Then I proceeded Manual Vacuum/full following
    FAQ - Hold'em Manager Poker Tracking Software :: Vacuum Analyze Database
    it was very fast (less than a minute) and the size hasn't decreased, rebooting didn't help. I use Postgres 8.3.

    Unfortunately the hint to create new db, then export, doesn't work for me because I have only 6Gb of free space left on the hard disk.

    So is there way to make vacuum really work ?

Similar Threads

  1. postgreSQL has a huge log file folder
    By httassadar in forum Manager General
    Replies: 2
    Last Post: 01-20-2010, 07:49 PM
  2. missing postgresql-8.3.msi file
    By zngl in forum Manager General
    Replies: 1
    Last Post: 08-19-2009, 09:07 PM
  3. Moving my PostgreSQL file.
    By bacon sashimi in forum Manager General
    Replies: 1
    Last Post: 04-22-2009, 04:06 PM
  4. moving the postgresql file
    By a breath of air in forum Manager General
    Replies: 1
    Last Post: 04-04-2009, 04:25 PM
  5. cannot find postgresql file
    By martj_01 in forum Manager General
    Replies: 1
    Last Post: 10-29-2008, 10:20 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
  •