opengauss基础 ps_setting 查看内存配置

Server：CentOS Linux release 7.6.1810 (Core) （3.10.0-957.el7.x86_64）
openGauss：2.0.0 企业版 centos_x86_64
DataStudio：2.0.0 windows_x86_64

查看内存配置信息

postgres=# select name,setting,source from pg_settings where name like '%work_mem%';    
         name         | setting |       source       
----------------------+---------+--------------------
 maintenance_work_mem | 131072  | configuration file
 psort_work_mem       | 524288  | default
 work_mem             | 65536   | configuration file

复制

postgres=# select name,short_desc,extra_desc from pg_settings where name like '%work_mem%';
         name         |                           short_desc                           |                                                      extr
a_desc                                                       
----------------------+----------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------
 maintenance_work_mem | Sets the maximum memory to be used for maintenance operations. | This includes operations such as VACUUM and CREATE INDEX.
 psort_work_mem       | Sets the maximum memory to be used for partial sort.           | This much memory can be used by each internal partial sort operation before switching to temporary disk files.
 work_mem             | Sets the maximum memory to be used for query workspaces.       | This much memory can be used by each internal sort operation and hash table before switching to temporary disk files.
(3 rows)

复制

配置文件

[omm@node1 ~]$ cd /opt/huawei/install/data/dn/
[omm@node1 dn]$ cat postgresql.conf | grep 'work_mem'
work_mem = 64MB				# min 64kB
maintenance_work_mem = 128MB		# min 1MB
[omm@node1 dn]$ 

复制

相关链接

• openGauss
• openGauss-Gitee
• CentOS
• 墨天轮社区

欢迎各位同学一起来交流学习心得！