micklf的博客

是否使用索引：gp=# explain select cjbh, jjbh, sfxq, sfsjsx, bccljg, cljgnr, spsj, zbld, ldclsj from jcj_cjxx_r where jjbh='20010015'; QUERY PLAN

介绍greenplum 4.3.8.0，基于PostgreSQL 8.2.15。Greenplum is regarded as the most scalable mission-critical analytical database。GP是Pivotal公司，将PostgreSQL增强后，把多实例组合，一起提供服务的MPP架构数据库。PB级的装载能力（支持50PB） 遵从SQL-92,

CREATE DATABASECREATE DATABASE name [ [WITH] [OWNER [=] dbowner] [TEMPLATE [=] template] [ENCODING [=] encoding] [TABLESPACE [=] tablespac

使能root给root设置密码sudo passwd -u root # sudo passwd root #主机名/etc/hostname /etc/hosts这两个文件都要改静态ip配置修改文件/etc/network/interfacesauto lo iface lo inet loopbackauto eth0 iface eth0 inet static address 192.168