邮件测试步骤
2017-11-14 5页 doc 20KB 17阅读
is_792768
暂无简介
举报
邮件测试步骤邮件测试步骤
Ò?. Please run explain verbose = '2014-01-01' & p9_start_date >= '2014-01-21'> 2. Please run explain analyze verbose = '2014-01-01' & p9_start_date >= '2014-01-21'>
??Öè
1.step enable_bitmapscan=on;
select * from ?íÃû and p9_start_date >='2014-01-01';
ex...
邮件测试步骤
Ò?. Please run explain verbose = '2014-01-01' & p9_start_date >= '2014-01-21'> 2. Please run explain analyze verbose = '2014-01-01' & p9_start_date >= '2014-01-21'>
??Öè
1.step enable_bitmapscan=on;
select * from ?íÃû and p9_start_date >='2014-01-01';
expalain analyze verbose select * from ?íÃû and p9_start_date >='2014-01-01';
2.step enabled_bitmapscan =off
select * from ?íÃû and p9_start_date >='2014-01-01';
explain select * from ?íÃû and p9_start_date >='2014-01-01';
3.step2: set enabled_bitmapscan=on;
seleect * from ?íÃû and p9_start_date >='2014-01-21';
expalain analyze verbose select * from ?íÃû and p9_start_date >='2014-01-21';
4.step enabled_bitmapscan=off;
select * from ?íÃû and p9_start_date >='2014-01-21';
expalain analyze verbose select * from ?íÃû and p9_start_date >='2014-01-21';
?þ.ÐÞ?Äclient_min_messages???ðÖ?ºóÖØÐÂ?âÊÔ
set client_min_messages=debug5;
1.step enable_bitmapscan=on;
select * from ?íÃû and p9_start_date >='2014-01-01';
expalain analyze verboseselect * from ?íÃû and p9_start_date >='2014-01-01';
2.step enabled_bitmapscan =off
select * from ?íÃû and p9_start_date >='2014-01-01';
explain analyze verbose select * from ?íÃû and p9_start_date >='2014-01-01';
3.step2: set enabled_bitmapscan=on;
seleect * from ?íÃû and p9_start_date >='2014-01-21';
expalain analyze verbose select * from ?íÃû and p9_start_date >='2014-01-21';
4.set enabled_bitmapscan=off;
select * from ?íÃû and p9_start_date >='2014-01-21';
expalain analyze verbose select * from ?íÃû and p9_start_date >='2014-01-21'; ?âÊÔÍêÖ?ºóÒª?Ä?ØÔ,À?µÄÖµ??
Èý. From your attachment , we find that the data is out from seg0 and seg9 , can you run below command in this two segments and check more , thanks. ÒÔÒÔÏÂÄ?Ê?µÇÂ?ÕâÁ?Ì?Ö??ú??
PGOPTIONS='-c gp_session_role=utility' psql -h by19ldssvdb1003 -p 40000 ldsdb ?øÐÐ?âÊÔ??Ëü??ËüÏÔÊ?µÄ?á?û??
1.step enable_bitmapscan=on;
select * from ?íÃû and p9_start_date >='2014-01-01';
expalain analyze verbose analyze verbose select * from ?íÃû and p9_start_date >='2014-01-01';
2.step enabled_bitmapscan =off
select * from ?íÃû and p9_start_date >='2014-01-01';
explain analyze verbose select * from ?íÃû and p9_start_date >='2014-01-01';
3.step2: set enabled_bitmapscan=on;
seleect * from ?íÃû and p9_start_date >='2014-01-21';
expalain analyze verbose select * from ?íÃû and p9_start_date >='2014-01-21';
4.step enabled_bitmapscan=off;
select * from ?íÃû and p9_start_date >='2014-01-21';
expalain analyze verbose select * from ?íÃû and p9_start_date >='2014-01-21';
PGOPTIONS='-c gp_session_role=utility' psql -h by19ldssvdb1007 -p 40001 ldsdb ?øÐÐ?âÊÔ?é??ËüÏÔÊ?µÄ?á?û??
1.step enable_bitmapscan=on;
select * from ?íÃû and p9_start_date >='2014-01-01';
expalain analyze verbose select * from ?íÃû and p9_start_date >='2014-01-01';
2.step enabled_bitmapscan =off
select * from ?íÃû and p9_start_date >='2014-01-01';
explain select * from ?íÃû and p9_start_date >='2014-01-01';
3.step2: set enabled_bitmapscan=on;
seleect * from ?íÃû and p9_start_date >='2014-01-21';
expalain analyze verbose select * from ?íÃû and p9_start_date >='2014-01-21';
4.step enabled_bitmapscan=off;
select * from ?íÃû and p9_start_date >='2014-01-21';
expalain analyze verbose select * from ?íÃû and p9_start_date >='2014-01-21';
ËÄ.????Ò??öÐÂ?í??ÃüÃûΪtodec_cust_id_conv_h_20140304_1_prt_44,
create one new table as select * from todec_cust_id_conv_h_20140304_1_prt_44, then create bitmap index on this table.Ö?ºóÖØÐÂ??ÕÕsetep1ºÍsetep2?????âÊÔ
1.step enable_bitmapscan=on;
select * from еÄ?íÃû and p9_start_date >='2014-01-01';
expalain analyze verbose select * from еÄ?íÃû and p9_start_date >='2014-01-01';
2.step enabled_bitmapscan =off
select * from еÄ?íÃû and p9_start_date >='2014-01-01';
explain analyze verbose select * from еÄ?íÃû and p9_start_date >='2014-01-01';
3.step2: set enabled_bitmapscan=on;
seleect * from еÄ?íÃû and p9_start_date >='2014-01-21';
expalain analyze verbose select * from еÄ?íÃû and p9_start_date >='2014-01-21';
4.step enabled_bitmapscan=off;
select * from еÄ?íÃû and p9_start_date >='2014-01-21';
expalain analyze verbose select * from еÄ?íÃû and p9_start_date >='2014-01-21';
/
本文档为【邮件测试步骤】，请使用软件OFFICE或WPS软件打开。作品中的文字与图均可以修改和编辑，
图片更改请在作品中右键图片并更换，文字修改请直接点击文字进行修改，也可以新增和删除文档中的内容。
[版权声明] 本站所有资料为用户分享产生，若发现您的权利被侵害，请联系客服邮件isharekefu@iask.cn，我们尽快处理。
本作品所展示的图片、画像、字体、音乐的版权可能需版权方额外授权，请谨慎使用。
网站提供的党政主题相关内容(国旗、国徽、党徽..)目的在于配合国家政策宣传，仅限个人学习分享使用，禁止用于任何广告和商用目的。
相关资料
热门搜索
- 安全生产管理规章制度范本与安全生产规章制度范本
- 美国纸材厚度PT表示法
- 细菌纤维素生物医学材料的现状及展望(可编辑)
- 省政府国资委中介机构信息库入库机构(会计师事务所)简明情况表
- 牧顧心聲--「十架七言」
- 讨论59136
- 渠道销售周工作报表
- 与三角形有关的角
- 让地球上的每颗星星都璀璨——《地球上的星星》的教育启示——李荣贵
- 国内外标准中非甲烷总烃无组织排放限值汇总
- 高中英语 The Picture of Dorian Gray道林格雷的画像课外阅读
- 3 展示环境空间创意设计观念
- 华东政法国际法真题名词解释集
- 课后练习翻译
- 安全生产管理规章制度范本与安全生产规章制度范本
- 美国纸材厚度PT表示法
- 细菌纤维素生物医学材料的现状及展望(可编辑)
- 省政府国资委中介机构信息库入库机构(会计师事务所)简明情况表
- 牧顧心聲--「十架七言」
- 讨论59136
- 渠道销售周工作报表
- 与三角形有关的角
- 让地球上的每颗星星都璀璨——《地球上的星星》的教育启示——李荣贵
- 国内外标准中非甲烷总烃无组织排放限值汇总
- 高中英语 The Picture of Dorian Gray道林格雷的画像课外阅读
- 3 展示环境空间创意设计观念
- 华东政法国际法真题名词解释集
- 课后练习翻译
你可能还喜欢
浙公网安备 33021202002483