Greenplum Database 数据仓库
Greenplum Database 数据仓库
1.官网
http://greenplum.org/
http://gpdb.docs.pivotal.io/43120/common/welcome.html
2.软件版本
greenplum-db-4.3.12.0-rhel5-x86_64
postgres (Greenplum Database) 8.2.15
3.安装
# vim /etc/selinux/config
SELINUX=disabled
系统内核优化
# vim /etc/sysctl.conf
kernel.shmmax = 500000000
kernel.shmmni = 4096
kernel.shmall = 4000000000
kernel.sem = 250 512000 100 2048
kernel.sysrq = 1
kernel.core_uses_pid = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.msgmni = 2048
net.ipv4.tcp_syncookies = 1
net.ipv4.conf.default.accept_source_route = 0
net.ipv4.tcp_tw_recycle = 1
net.ipv4.tcp_max_syn_backlog = 4096
net.ipv4.conf.all.arp_filter = 1
net.ipv4.ip_local_port_range = 10000 65535
net.core.netdev_max_backlog = 10000
net.core.rmem_max = 2097152
net.core.wmem_max = 2097152
vm.overcommit_memory = 2
# vim /etc/security/limits.conf
* soft nofile 65536
* hard nofile 65536
* soft nproc 131072
* hard nproc 131072
# vim /etc/fstab
/dev/mapper/cl_greenplum0-root / xfs
nodev,noatime,nobarrier,inode64,allocsize=16m 0 0
评论0