PostgreSQL 9.3.2 Performance issues
От | |
---|---|
Тема | PostgreSQL 9.3.2 Performance issues |
Дата | |
Msg-id | 20140124092332.5a830134ae84016b0174832fdc1a3173.9b700c639c.wbe@email11.secureserver.net обсуждение исходный текст |
Ответы |
Re: PostgreSQL 9.3.2 Performance issues
|
Список | pgsql-performance |
<span style="font-family:Verdana; color:#000000; font-size:10pt;"><div><span class="post-format-icon">We have 64GB of Memoryon 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 recommendedparameters for memory management in PostgreSQL.<br /></div><div class="first-para"><br /></div><div>About <strong>shared_buffers</strong>:</div><ul><li>Below2GB, set to 20% of total system memory.<li>Below 32GB, set to 25% of totalsystem memory.<li>Above 32GB, set to 8GB</ul><div>About <strong>work_mem</strong>, this parameter can cause a huge speed-upif set properly, however it can use that amount of memory per planning node.<br /> Here are some recommendationsto set it up.</div><ul><li>Start low: 32-64MB<li>Look for ‘temporary file’ lines in logs<li>Set to 2-3x thelargest temp file</ul><div>About <strong>maintenance_work_mem</strong>, some recommendations were:</div><ul><li>10% ofsystem memory, up to1GB<li>Maybe even higher if you are having VACUUM problems</ul><div>About <strong>effective_cache_size</strong>,guidelines suggested.</div><ul><li>Set to the amount of file system cache available<li>Ifyou don’t know, set it to 50% of total system memory</ul><div>We have real time 24/7 data ingest processesrunning 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>
В списке pgsql-performance по дате отправления: