postgresql.conf - optimizing
Results 1 to 4 of 4
  1. #1
    Senior Member
    Join Date
    Dec 2009
    Posts
    305

    Default postgresql.conf - optimizing

    I found this:

    http://hm2faq.holdemmanager.com/ques...+Modifications

    PostgreSQL

    Edit PosgreSQL.conf file in the SQL C:/Program Files/8.x/data folder.
    Do not use the Tuning Wizard. On some systems it will make unecessary changes to the postgresql.conf, resulting in being unable to connect to the database!
    If this problem occurs, go to the 8.4/data folder, delete postgresql.conf. Rename the backup postgresql.conf.2009(data xxxxxxxx) to "postgresql.conf". Now reboot.

    Recommended changes:
    shared_buffers = MB (set this to 20% of your system memory, but not more than 1000 MB.... round it off to 128 MB, 256 MB, 512 MB or 768 MB)
    effective_cache_size = MB (set this to 2x the size of the shared_buffers)




    My shared_buffers is set to 1024mb. Why does it say not to go higher than 1000? Is this information just outdated? Since I have 16gb of ram, can I set it to 2048?

    My effective_cache_size = 1024mb. I guess Ill try changing this to 2048. Should I change shared_buffers to 2048, and set this to 4096?

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

    Default

    You can increase the values, but when that FAQ was written, higher values did NOT result in faster (import) speeds.

    In fact, sometimes the PostgreSQL server would even stop running if the values were set too high.
    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
    Dec 2009
    Posts
    305

    Default

    Yes, I tried shared_buffers = 2048MB and postgres would not start.

    What about postgres 9.0 or 9.2? I believe I've read that they're 64-bit and can utilize higher shared_buffers.

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

    Default

    Default shared_buffers = 32MB?
    If you increase this to 256MB-->512MB---> 1024MB, etc. the performance increase is minimal.

    Best case scenario the import speeds will go up with 15%. (but this is only after you make some changes to the work_mem, wal buffers and temp_buffers which seem to have a higher impact on performance)

    All these tweaks are designed for PostgreSQL 8.4, read: http://forums.holdemmanager.com/mana...ease-tips.html tip #7 on the list.

    Both HoldemManager and PokerTracker users tried nearly every setting how it would improve performance.
    The PokerTracker thread is an interesting read: https://de.pokertracker.com/forums/v...p?f=15&t=30450

    I don't know how effective all these tweaks still are with PostgreSQL 9.2.
    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

Similar Threads

  1. postgresql.conf cannot be tuned
    By nokl in forum Manager General
    Replies: 10
    Last Post: 09-27-2011, 12:32 PM
  2. pg_hba.conf not saving changes?
    By brainfry35 in forum Manager General
    Replies: 3
    Last Post: 12-19-2010, 11:37 PM
  3. Poker Heaven: Custom HUD conf. dosent work!
    By Suusk in forum Manager General
    Replies: 5
    Last Post: 11-02-2010, 01:15 PM
  4. Optimizing PostgreSQL breaks it
    By steel108 in forum Manager General
    Replies: 1
    Last Post: 10-23-2010, 12:57 AM
  5. Popup conf. HUD Layout
    By AdmObscure in forum Share your HUD configurations
    Replies: 2
    Last Post: 03-02-2010, 01:29 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
  •