Results 1 to 3 of 3

Thread: Too Much RAM?

  1. #1
    Join Date
    Oct 2010
    Orlando, FL
    Provided Answers: 1

    Unanswered: Too Much RAM?

    Can performance of my PostgreSQL database server be in any way negatively impacted by the system having too much physical RAM. Lets say I have a master database server running PostgreSQL 9.1.2 & we had 96 GB's of physical RAM. Would there be any performance implications to a server having far more RAM than needed to perform it's functions?

  2. #2
    Join Date
    Jun 2004
    Arizona, USA
    I wouldn't think so. What are your configuration settings for memory?
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

  3. #3
    Join Date
    Mar 2012
    There is no downside to a server having more physical ram than you need. It is a nice problem to have because you can keep your entire database in memory. Allocate enough buffers to hold it all, right after startup initiate something that does table scans of the whole thing to ensure its all in memory quickly and you have an in memory db. Sweet.

    There is a downside to allocating more ram to the database than the server has ( swapping / paging etc. ).

Posting Permissions

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