Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id EF111133798E for ; Thu, 11 Nov 2010 03:04:00 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 34612-01 for ; Thu, 11 Nov 2010 07:03:53 +0000 (UTC) Received: from mx3.hub.org (mx3.hub.org [206.223.169.73]) by mail.postgresql.org (Postfix) with ESMTP id 1064E133616B for ; Thu, 11 Nov 2010 03:03:53 -0400 (AST) X-Greylist: delayed 21:19:04.339768 by SQLgrey-1.7.6 Received: from smtpbg52.qq.com (smtpbg52.qq.com [64.71.138.43]) by mx3.hub.org (Postfix) with SMTP id DC3EF37B4AB for ; Thu, 11 Nov 2010 03:03:51 -0400 (AST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=qq.com; s=s0907; t=1289459029; bh=BMXOUzul6tpWhnyzdBGXkIQjSg26goXsTBjm9bLQIHI=; h=X-QQ-SSF:X-QQ-BUSINESS-ORIGIN:X-Originating-IP:X-QQ-STYLE: X-QQ-mid:From:To:Cc:Subject:Mime-Version:Content-Type: Content-Transfer-Encoding:Date:X-Priority:Message-ID:X-QQ-MIME: X-Mailer:X-QQ-Mailer; b=Tq1Vrb2Vewhs68iW+cRhIITXMddWv3RQIY6zUkIilN2xXgh291J2IdccjUNDH84m1 2hTJbrtgRV4mMMYSk5ggnX71lnBmw9BunG8R8Im0KV/5kKyRf0StHClhKc41fKf X-QQ-SSF: 0000000000000040 X-QQ-BUSINESS-ORIGIN: 2 X-Originating-IP: 202.111.113.167 X-QQ-STYLE: X-QQ-mid: webmail326t1289459026t3775693 From: "=?gbk?B?vrKwssvC?=" To: "=?gbk?B?dHY=?=" Cc: "=?gbk?B?cGdzcWwtcGVyZm9ybWFuY2U=?=" , "=?gbk?B?dGds?=" Subject: Re: Why dose the planner select one bad scan plan. Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_4CDB9551_DCD49998_36DAAEB8" Content-Transfer-Encoding: 8Bit Date: Thu, 11 Nov 2010 15:03:45 +0800 X-Priority: 3 Message-ID: X-QQ-MIME: TCMime 1.0 by Tencent X-Mailer: QQMail 2.x X-QQ-Mailer: QQMail 2.x X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201011/214 X-Sequence-Number: 41238 This is a multi-part message in MIME format. ------=_NextPart_4CDB9551_DCD49998_36DAAEB8 Content-Type: text/plain; charset="gbk" Content-Transfer-Encoding: base64 VGhhbmtzIGZvciB5b3VyIGFuc3dlciEgQW5kIEkgYW0gc29ycnkgZm9yIHRyYWRpbmcgdGhl IHF1ZXN0aW9uIGFzIGEgYnVnLCBhbmQgc2VuZCBpdCB0byAnYnVncycgbWFpbGluZy1saXN0 LiANCiANCkJ1dCBJIGRvdWJ0IHlvdXIgYW5zd2VyLiBJIHRoaW5rIHRoZSBlc3NlbmNlIG9m IHRoZSBwcm9ibGVtIGlzIHdoZW4gdGhlIHBsYW5uZXIgc2VsZWN0cyAnQml0bWFwIEluZGV4 IFNjYW4nIGFuZCBob3cgdGhlIHBsYW5uZXIgY29tcHV0ZXMgdGhlIGNvc3Qgb2YgJ0JpdG1h cCBJbmRleCBTY2FuJy4gDQogDQpUb20gTGFuZSBzYWlkIKGwSW4gcHJpbmNpcGxlIGEgYml0 bWFwIGluZGV4IHNjYW4gc2hvdWxkIGJlIHNpZ25pZmljYW50bHkgZmFzdGVyIGlmIHRoZSBp bmRleCBjYW4gcmV0dXJuIHRoZSBiaXRtYXAgbW9yZSBvciBsZXNzICJuYXRpdmVseSIgcmF0 aGVyIHRoYW4gaGF2aW5nIHRvIGNvbnN0cnVjdCBpdC4gTXkgcmVjb2xsZWN0aW9uIHRob3Vn aCBpcyB0aGF0IGEgc2lnbmlmaWNhbnQgYW1vdW50IG9mIHdvcmsgaXMgbmVlZGVkIHRvIG1h a2UgdGhhdCBoYXBwZW4sIGFuZCB0aGF0IHRoZXJlIGlzIG5vIGV4aXN0aW5nIHBhdGNoIHRo YXQgdGFja2xlZCB0aGUgcHJvYmxlbS4gU28gSSdtIG5vdCBzdXJlIHRoYXQgdGhpcyByZXBv cnQgc2hvdWxkIGJlIHRha2VuIGFzIGluZGljYXRpbmcgdGhhdCB0aGVyZSdzIG5vIGNoYW5j ZSBvZiBhIFNFTEVDVCBwZXJmb3JtYW5jZSBpbXByb3ZlbWVudC4gV2hhdCBpdCBkb2VzIHNh eSBpcyB0aGF0IHdlIGhhdmUgdG8gZG8gdGhhdCB3b3JrIGlmIHdlIHdhbnQgdG8gbWFrZSBi aXRtYXAgaW5kZXhlcyB1c2VmdWwuobENCiANCk9rYXksIEkgd2FudCB0byBrbm93IGhvdyB0 aGUgcGxhbm5lciBjb21wdXRlcyB0aGUgY29zdCBvZiBjb25zdHJ1Y3RpbmcgYml0bWFwLiBB bmQgd2hlbiB0aGUgcGxhbm5lciBjb21wdXRlcyB0aGUgY29zdCBvZiAnQml0bWFwIEluZGV4 IFNjYW4nLCBpZiBpdCBjb25zaWRlcnMgdGhlIGluZmx1ZW5jZSBvZiBtZW1vcnkgY2FjaGU/ IEFzIHdoZW4gSSBkbyBub3QgY2xlYXIgdGhlIG1lbW9yeSBjYWNoZSwgSSBmaW5kIHRoZSAn Qml0bWFwIEluZGV4IFNjYW4nIGlzIHJlYWwgZmFzdCB0aGFuICdTZXEgU2NhbicuDQogDQog QmVzdCBSZWdhcmRzIQ0KIA0KQXNlbg== ------=_NextPart_4CDB9551_DCD49998_36DAAEB8 Content-Type: text/html; charset="gbk" Content-Transfer-Encoding: base64 PGRpdj4NCg0KPHAgY2xhc3M9Ik1zb05vcm1hbCIgYWxpZ249ImxlZnQiIHN0eWxlPSJ0ZXh0 LWFsaWduOmxlZnQ7bXNvLXBhZ2luYXRpb246d2lkb3ctb3JwaGFuIj48c3BhbiBsYW5nPSJF Ti1VUyIgc3R5bGU9ImZvbnQtc2l6ZToxMi4wcHQ7Zm9udC1mYW1pbHk6y87M5Tttc28tYmlk aS1mb250LWZhbWlseTrLzszlOw0KbXNvLWZvbnQta2VybmluZzowcHQiPlRoYW5rcyBmb3Ig eW91ciBhbnN3ZXIhIEFuZCBJIGFtIHNvcnJ5IGZvciB0cmFkaW5nIHRoZQ0KcXVlc3Rpb24g YXMgYSBidWcsIGFuZCBzZW5kIGl0IHRvICdidWdzJyBtYWlsaW5nLWxpc3QuIDwvc3Bhbj48 L3A+DQoNCjxwIGNsYXNzPSJNc29Ob3JtYWwiIGFsaWduPSJsZWZ0IiBzdHlsZT0idGV4dC1h bGlnbjpsZWZ0O21zby1wYWdpbmF0aW9uOndpZG93LW9ycGhhbiI+PHNwYW4gbGFuZz0iRU4t VVMiIHN0eWxlPSJmb250LXNpemU6MTIuMHB0O2ZvbnQtZmFtaWx5OsvOzOU7bXNvLWJpZGkt Zm9udC1mYW1pbHk6y87M5TsNCm1zby1mb250LWtlcm5pbmc6MHB0Ij5CdXQgSSBkb3VidCB5 b3VyIGFuc3dlci4gSSB0aGluayB0aGUgZXNzZW5jZSBvZiB0aGUgcHJvYmxlbQ0KaXMgd2hl biB0aGUgcGxhbm5lciBzZWxlY3RzICdCaXRtYXAgSW5kZXggU2NhbicgYW5kIGhvdyB0aGUg cGxhbm5lciBjb21wdXRlcyB0aGUNCmNvc3Qgb2YgJ0JpdG1hcCBJbmRleCBTY2FuJy4gPC9z cGFuPjwvcD4NCg0KPHAgY2xhc3M9Ik1zb05vcm1hbCIgYWxpZ249ImxlZnQiIHN0eWxlPSJ0 ZXh0LWFsaWduOmxlZnQ7bXNvLXBhZ2luYXRpb246d2lkb3ctb3JwaGFuIj48c3BhbiBsYW5n PSJFTi1VUyIgc3R5bGU9ImZvbnQtc2l6ZToxMi4wcHQ7Zm9udC1mYW1pbHk6y87M5Tttc28t YmlkaS1mb250LWZhbWlseTrLzszlOw0KbXNvLWZvbnQta2VybmluZzowcHQiPlRvbSBMYW5l IHNhaWQgobBJbiBwcmluY2lwbGUgYSBiaXRtYXAgaW5kZXggc2NhbiBzaG91bGQgYmUgc2ln bmlmaWNhbnRseSBmYXN0ZXIgaWYgdGhlIGluZGV4IGNhbiByZXR1cm4gdGhlIGJpdG1hcCBt b3JlIG9yIGxlc3MNCiJuYXRpdmVseSIgcmF0aGVyIHRoYW4gaGF2aW5nIHRvIGNvbnN0cnVj dCBpdC4gTXkgcmVjb2xsZWN0aW9uIHRob3VnaA0KaXMgdGhhdCBhIHNpZ25pZmljYW50IGFt b3VudCBvZiB3b3JrIGlzIG5lZWRlZCB0byBtYWtlIHRoYXQgaGFwcGVuLCBhbmQgdGhhdA0K dGhlcmUgaXMgbm8gZXhpc3RpbmcgcGF0Y2ggdGhhdCB0YWNrbGVkIHRoZSBwcm9ibGVtLiBT byBJJ20gbm90IHN1cmUgdGhhdCB0aGlzDQpyZXBvcnQgc2hvdWxkIGJlIHRha2VuIGFzIGlu ZGljYXRpbmcgdGhhdCB0aGVyZSdzIG5vIGNoYW5jZSBvZiBhIFNFTEVDVA0KcGVyZm9ybWFu Y2UgaW1wcm92ZW1lbnQuIFdoYXQgaXQgZG9lcyBzYXkgaXMgdGhhdCB3ZSBoYXZlIHRvIGRv IHRoYXQgd29yayBpZiB3ZQ0Kd2FudCB0byBtYWtlIGJpdG1hcCBpbmRleGVzIHVzZWZ1bC6h sTwvc3Bhbj48L3A+DQoNCjxwIGNsYXNzPSJNc29Ob3JtYWwiIGFsaWduPSJsZWZ0IiBzdHls ZT0idGV4dC1hbGlnbjpsZWZ0O21zby1wYWdpbmF0aW9uOndpZG93LW9ycGhhbiI+PHNwYW4g bGFuZz0iRU4tVVMiIHN0eWxlPSJmb250LXNpemU6MTIuMHB0O2ZvbnQtZmFtaWx5OsvOzOU7 bXNvLWJpZGktZm9udC1mYW1pbHk6y87M5TsNCm1zby1mb250LWtlcm5pbmc6MHB0Ij5Pa2F5 LCBJIHdhbnQgdG8ga25vdyBob3cgdGhlIHBsYW5uZXIgY29tcHV0ZXMgdGhlIGNvc3Qgb2YN CmNvbnN0cnVjdGluZyBiaXRtYXAuIEFuZCB3aGVuIHRoZSBwbGFubmVyIGNvbXB1dGVzIHRo ZSBjb3N0IG9mICdCaXRtYXAgSW5kZXggU2NhbicsDQppZiBpdCBjb25zaWRlcnMgdGhlIGlu Zmx1ZW5jZSBvZiBtZW1vcnkgY2FjaGU/IEFzIHdoZW4gSSBkbyBub3QgY2xlYXIgdGhlDQpt ZW1vcnkgY2FjaGUsIEkgZmluZCB0aGUgJ0JpdG1hcCBJbmRleCBTY2FuJyBpcyByZWFsIGZh c3QgdGhhbiAnU2VxIFNjYW4nLjwvc3Bhbj48L3A+DQoNCjxwIGNsYXNzPSJNc29Ob3JtYWwi IGFsaWduPSJsZWZ0IiBzdHlsZT0idGV4dC1hbGlnbjpsZWZ0O21zby1wYWdpbmF0aW9uOndp ZG93LW9ycGhhbiI+PHNwYW4gbGFuZz0iRU4tVVMiIHN0eWxlPSJmb250LXNpemU6MTIuMHB0 O2ZvbnQtZmFtaWx5OsvOzOU7bXNvLWJpZGktZm9udC1mYW1pbHk6y87M5TsNCm1zby1mb250 LWtlcm5pbmc6MHB0Ij48bzpwPiA8L286cD48L3NwYW4+PHNwYW4gbGFuZz0iRU4tVVMiIHN0 eWxlPSJmb250LXNpemU6MTIuMHB0O2ZvbnQtZmFtaWx5OsvOzOU7bXNvLWJpZGktZm9udC1m YW1pbHk6y87M5TsNCm1zby1mb250LWtlcm5pbmc6MHB0Ij5CZXN0IFJlZ2FyZHMhPC9zcGFu PjwvcD4NCg0KPHAgY2xhc3M9Ik1zb05vcm1hbCIgYWxpZ249ImxlZnQiIHN0eWxlPSJ0ZXh0 LWFsaWduOmxlZnQ7bXNvLXBhZ2luYXRpb246d2lkb3ctb3JwaGFuIj48c3BhbiBsYW5nPSJF Ti1VUyIgc3R5bGU9ImZvbnQtc2l6ZToxMi4wcHQ7Zm9udC1mYW1pbHk6y87M5Tttc28tYmlk aS1mb250LWZhbWlseTrLzszlOw0KbXNvLWZvbnQta2VybmluZzowcHQiPkFzZW48L3NwYW4+ PC9wPg0KDQo8L2Rpdj4= ------=_NextPart_4CDB9551_DCD49998_36DAAEB8--