The default value for this parameter, which is set in nf, is: #work_mem = 4MB Hash tables are used in hash joins and hash based aggregation. Sort operations are used for order by, distinct, and merge join operations. The work_mem parameter basically provides the amount of memory to be used by internal sort operations and hash tables before writing to temporary disk files. 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 kommentar(er)
