PostgresQL
Results 1 to 4 of 4

Thread: PostgresQL

  1. #1
    Junior Member
    Join Date
    Sep 2008
    Posts
    13

    Default PostgresQL

    Hello,

    (Not sure if this subforum is the right place for this thread).

    My PostgresQL folder takes up a lot of CPU memory.
    C:\Program Files\PostgreSQL\8.4\data\base contains about 1000 files (what are they?!) of about 20gb.

    Can I delete them or will this get me in trouble? Is there a way to stop PostgresQL putting all this shit on my CPU? (I allready deleted 20gb of log files from the pg_log folder).

    Thanks for the help!

    Brein

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

    Default

    The base folder contains the actual database. Don't delete any files in the /data folder and subfolders.


    When every hand is imported the data from the hand is stored in hundreds of tables/indexes:
    what are your holecards, list of players, action on the flop, etc.
    1 million hands take up at least 10 GB of space.
    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
    Junior Member
    Join Date
    Sep 2008
    Posts
    13

    Default

    Ok, thank you.

    Somewhere else I read that the files in C:\Program Files\PostgreSQL\8.4\data\pg_log could be deleted without difficulty. Isn't this true though? (Allready deleted them)...

  4. #4
    Holdem Manager Support Sarek's Avatar
    Join Date
    May 2010
    Location
    Eridani 40
    Posts
    22,519

    Default

    Yes, contents of pg_log can be deleted.
    And you can set Postgre to not write these logs in the future.
    http://forums.holdemmanager.com/mana...heres-how.html

Similar Threads

  1. PostgreSQL
    By Gabor Muller in forum Manager General
    Replies: 1
    Last Post: 07-23-2011, 06:07 AM
  2. PostgreSQL
    By BuckyOHare in forum Manager General
    Replies: 5
    Last Post: 04-28-2011, 02:09 PM
  3. Please Help with PostgreSQL
    By RayN3s in forum Manager General
    Replies: 1
    Last Post: 12-17-2009, 05:40 PM
  4. Do I have to use PostgreSQL?
    By JBYRNE99 in forum Manager General
    Replies: 1
    Last Post: 05-20-2009, 01:55 PM
  5. PostgreSQL
    By hangchiong in forum Manager General
    Replies: 1
    Last Post: 02-07-2009, 01:15 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
  •