<html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;"><div> <span class="post-format-icon">We have 64GB of Memory on RHEL 6.4</span></div><div><span class="post-format-icon"><br></span></div> <div class="first-para"><code>shared_buffers = 8GB<br> work_mem = 64MB<br> maintenance_work_mem = 1GB<br> effective_cache_size = 48GB</code></div><div class="first-para"><br></div><div class="first-para">I found this list of recommended parameters for memory management in PostgreSQL.<br> </div><div class="first-para"><br></div> <div>About <strong>shared_buffers</strong>:</div> <ul><li>Below 2GB, set to 20% of total system memory.</li><li>Below 32GB, set to 25% of total system memory.</li><li>Above 32GB, set to 8GB</li></ul> <div>About <strong>work_mem</strong>, this parameter can cause a huge speed-up if set properly, however it can use that amount of memory per planning node.<br> Here are some recommendations to set it up.</div> <ul><li>Start low: 32-64MB</li><li>Look for ‘temporary file’ lines in logs</li><li>Set to 2-3x the largest temp file</li></ul> <div>About <strong>maintenance_work_mem</strong>, some recommendations were:</div> <ul><li>10% of system memory, up to1GB</li><li>Maybe even higher if you are having VACUUM problems</li></ul> <div>About <strong>effective_cache_size</strong>, guidelines suggested.</div> <ul><li>Set to the amount of file system cache available</li><li>If you don’t know, set it to 50% of total system memory</li></ul><div>We have real time 24/7 data ingest processes running on our 9.3.2 database 7TB in size<br></div><div><br></div><div>Do these settings look correct for 9.3.2?</div><div><br></div><div>thanks</div><div></div></span></body></html>