✳flâneur — a map of the web's best reading

How to tune PostgreSQL for memory | EDB

enterprisedb.com · 22 words · saved by 1 readers

This article looks at parameters that can be used to help manage memory in PostgreSQL. Recommended settings for each parameter are also provided. 1. Shared_buffers (integer) 2. Work_mem (integer) 3. Maintenance_work_mem (integer) 4. Effective_cache_size (integer) In this post, we are going to look at some of the important GUC parameters recommended for memory management in PostgreSQL, which is helpful for improving the performance of your database server. All of these parameters reside under the postgresql.conf file (inside $PDATA directory), which manages the configurations of the database server. The shared_buffers parameter determines how much memory is dedicated to the server for caching data. The default value for this parameter, which is set in postgresql.conf, is: The value should be set to 15% to 25% of the machine’s total RAM. For example: if your machine’s RAM size is 32 GB, then the recommended value for shared_buffers is 8 GB. Please note that the database server needs to b

blur focus focusin focusout resize scroll click dblclick mousedown mouseup mousemove mouseover mouseout mouseenter mouseleave change select submit keydown keypress keyup contextmenu

Explore this link on the map →

related reading