GreenPlum参数设置
注:segment host上是4个primary instance,4个mirror instance.
cat /gpmaster/gp-1/postgresql.conf
(1)、 shared_buffers(local, max_connections*16K)
shared_buffers = 1600MB # master、standby
shared_buffers = 200MB # segment
(2)、 work_mem(,global,物理内存的2%-4%)
work_mem = 640MB # master、standby
(3)、 effective_cache_size(master节点,设为物理内存的85%,15032385536)
effective_cache_size = 9600MB
(4)、 mainteance_work_mem(global,CREATE INDEX, VACUUM等时用到)
maintenance_work_mem = 800MB
(5)、 max_connections(local,最大连接数)
max_connections = 200 #(master、standby)
max_connections = 1200 #(segment)
(6)、 max_prepared_transactions(local,与master最大连接数相同)
max_prepraed_transacrions=300 #(master与segment instance相同)
注:segment host上是4个primary instance,4个mirror instance.
cat /gpmaster/gp-1/postgresql.conf
(1)、 shared_buffers(local, max_connections*16K)
shared_buffers = 1600MB # master、standby
shared_buffers = 200MB # segment
(2)、 work_mem(,global,物理内存的2%-4%)
work_mem = 640MB # master、standby
(3)、 effective_cache_size(master节点,设为物理内存的85%,15032385536)
effective_cache_size = 9600MB
(4)、 mainteance_work_mem(global,CREATE INDEX, VACUUM等时用到)
maintenance_work_mem = 800MB
(5)、 max_connections(local,最大连接数)
max_connections = 200 #(master、standby)
max_connections = 1200 #(segment)
(6)、 max_prepared_transactions(local,与master最大连接数相同)
max_prepraed_transacrions=300 #(master与segment instance相同)