GreenPlum
bruce_wang_janet
人生有三宝:终身运动,终身学习,终身反醒.吸收新知,提高效率,懂得相处,成就自己,也成就他人,创造最高价值.
展开
-
hawq 3 执行慢
"Aggregate (cost=1520822218.88..1520822218.89 rows=1 width=8)"" Rows out: Avg 1.0 rows x 1 workers. Max/Last(seg-1:hawq2/seg-1:hawq2) 1/1 rows with 6776880/6776880 ms to end, start offset by 1.2原创 2017-01-16 13:56:58 · 393 阅读 · 0 评论 -
hawq执行慢sql
执行语句为: explain analyze select count(*) from L_T054 a join L_T120 b on a.d020=b.d020 执行计划为: "Aggregate (cost=1520822218.88..1520822218.89 rows=1 width=8)"" Rows out: Avg 1.0 ro原创 2017-01-12 11:45:34 · 725 阅读 · 0 评论 -
hawq2 sql
set hawq_rm_stmt_vseg_memory = '2GB';set hawq_rm_nvseg_perquery_perseg_limit = 12 ;explain analyze select count(*) from L_T054 a join L_T120 b on a.d020=b.d020"Aggregate (cost=原创 2017-01-13 12:54:54 · 442 阅读 · 0 评论 -
hawq4 查询慢
"Aggregate (cost=1536786884.36..1536786884.37 rows=1 width=8)"" Rows out: Avg 1.0 rows x 1 workers. Max/Last(seg-1:hawq2/seg-1:hawq2) 1/1 rows with 6649618/6649618 ms to end, start offset by 113原创 2017-01-18 00:52:56 · 538 阅读 · 1 评论 -
Greenplum 安装方法
1. 下载文件 greenplum-db-4.3.10.0-build-1-rhel5-x86_64.bin2. 执行命令 ./greenplum-db-4.3.10.0-build-1-rhel5-x86_64.bin 查看/usr/local目录下必须有greenplum_db目录3. 编辑 gpinitsystem_config installgpdb.sh原创 2016-12-11 08:56:48 · 1186 阅读 · 0 评论