How to tune PostgreSQL for memory | EDB

enterprisedb.com · 434 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

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. shared_buffers (integer) 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: #shared_buffers = 128MB The value should be set to…

How to tune PostgreSQL for memory | EDB

related reading