邮件测试步骤邮件测试步骤
Ò?. 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,我们尽快处理。
本作品所展示的图片、画像、字体、音乐的版权可能需版权方额外授权,请谨慎使用。
网站提供的党政主题相关内容(国旗、国徽、党徽..)目的在于配合国家政策宣传,仅限个人学习分享使用,禁止用于任何广告和商用目的。