![]() Please note that the database server needs to be restarted after this change. For example: if your machine’s RAM size is 32 GB, then the recommended value for shared_buffers is 8 GB. The value should be set to 15% to 25% of the machine’s total RAM. The default value for this parameter, which is set in nf, is: #shared_buffers = 128MB The shared_buffers parameter determines how much memory is dedicated to the server for caching data. All of these parameters reside under the nf file (inside $PDATA directory), which manages the configurations of the database server. ![]() 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. Recommended settings for each parameter are also provided. This article looks at parameters that can be used to help manage memory in PostgreSQL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |