Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id D1AC314518EA for ; Thu, 8 Dec 2011 22:01:33 -0400 (AST) Received: from [119.161.170.176] (helo=MAIL.kingview.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RYpmC-0005qC-6w for pgsql-sql@postgresql.org; Fri, 09 Dec 2011 02:01:33 +0000 Received: from zhoufeng ([172.16.3.16]) by MAIL.kingview.com with Microsoft SMTPSVC(6.0.3790.1830); Fri, 9 Dec 2011 09:38:56 +0800 Date: Fri, 9 Dec 2011 09:58:23 +0800 From: "feng.zhou" To: "pgsql-sql" References: <201112090944451236494@wellintech.com> Subject: Re: Query Timeout Question Message-ID: <201112090958236709111@wellintech.com> X-mailer: Foxmail 6, 15, 201, 22 [cn] Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=====003_Dragon215355750277_=====" X-OriginalArrivalTime: 09 Dec 2011 01:38:56.0140 (UTC) FILETIME=[50B254C0:01CCB613] X-Host-Lookup-Failed: Reverse DNS lookup failed for 119.161.170.176 (failed) X-Pg-Spam-Score: 2.2 (++) X-Archive-Number: 201112/33 X-Sequence-Number: 36094 This is a multi-part message in MIME format. --=====003_Dragon215355750277_===== Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: base64 c29ycnksIHRpbWVvdXQgaXMgMTUgc2Vjb25kcw0KDQoNCjIwMTEtMTItMDkgDQoNCg0KDQpmZW5n Lnpob3UgDQoNCg0KDQq3orz+yMujuiBmZW5nLnpob3UgDQq3osvNyrG85KO6IDIwMTEtMTItMDkg IDA5OjI1OjQ5IA0KytW8/sjLo7ogcGdzcWwtc3FsIA0Ks63LzaO6IA0K1vfM4qO6IFtTUUxdIFF1 ZXJ5IFRpbWVvdXQgUXVlc3Rpb24gDQogDQpIaQ0KSSBzZXQgcXVlcnkgdGltZW91dCBpbiBjb2Rl IGJ5IHVzaW5nIFNRTFNldFN0bXRBdHRyIE9EQkMgQVBJIC4NCg0KU1FMU2V0U3RtdEF0dHIoIFN0 YXRlbWVudEhhbmRsZSwgU1FMX0FUVFJfUVVFUllfVElNRU9VVCwgKFNRTFBPSU5URVIpdGltZW91 dCwgMCApIDsNClNRTEV4ZWN1dGUoU3RhdGVtZW50SGFuZGxlKTsNCg0KQnV0IEkgZmluZCB0aGlz IHNldHRpbmcgaGFzIG5vIGVmZmVjdC5CZWZvcmUgYWRkaW5nIHRpbWVvdXQgc2V0dGluZywgU1FM RXhlY3V0ZSBjb3N0cyA0NyBzZWNvbmRzLkFmdGVyIGFkZGluZyB0aW1lb3V0LCBjb3N0aW5nIHRp bWUgaXMgc2FtZS4NClBvc3RncmVzIFNRTCB2ZXJzaW9uIDguNC4yLCBPREJDIGRyaXZlciA4LjQu Mg0KDQoyMDExLTEyLTA5IA0KDQoNCg0KZmVuZy56aG91IA0K --=====003_Dragon215355750277_===== Content-Type: text/html; charset="gb2312" Content-Transfer-Encoding: base64 PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv L0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PWdi MjMxMiIgaHR0cC1lcXVpdj1Db250ZW50LVR5cGU+DQo8TUVUQSBuYW1lPUdFTkVSQVRPUiBjb250 ZW50PSJNU0hUTUwgOC4wMC42MDAxLjE4OTI4Ij48TElOSyByZWw9c3R5bGVzaGVldCANCmhyZWY9 IkJMT0NLUVVPVEV7bWFyZ2luLVRvcDogMHB4OyBtYXJnaW4tQm90dG9tOiAwcHg7IG1hcmdpbi1M ZWZ0OiAyZW19Ij4NCjxNRVRBIG5hbWU9R0VORVJBVE9SIGNvbnRlbnQ9Ik1TSFRNTCA2LjAwLjI5 MDAuMjE4MCI+DQo8U1RZTEU+QGZvbnQtZmFjZSB7DQoJZm9udC1mYW1pbHk6IMvOzOU7DQp9DQpA Zm9udC1mYWNlIHsNCglmb250LWZhbWlseTogVmVyZGFuYTsNCn0NCkBmb250LWZhY2Ugew0KCWZv bnQtZmFtaWx5OiBAy87M5TsNCn0NCkBwYWdlIFNlY3Rpb24xIHtzaXplOiA1OTUuM3B0IDg0MS45 cHQ7IG1hcmdpbjogNzIuMHB0IDkwLjBwdCA3Mi4wcHQgOTAuMHB0OyBsYXlvdXQtZ3JpZDogMTUu NnB0OyB9DQpQLk1zb05vcm1hbCB7DQoJVEVYVC1KVVNUSUZZOiBpbnRlci1pZGVvZ3JhcGg7IFRF WFQtQUxJR046IGp1c3RpZnk7IE1BUkdJTjogMGNtIDBjbSAwcHQ7IEZPTlQtRkFNSUxZOiAiVGlt ZXMgTmV3IFJvbWFuIjsgRk9OVC1TSVpFOiAxMC41cHQNCn0NCkxJLk1zb05vcm1hbCB7DQoJVEVY VC1KVVNUSUZZOiBpbnRlci1pZGVvZ3JhcGg7IFRFWFQtQUxJR046IGp1c3RpZnk7IE1BUkdJTjog MGNtIDBjbSAwcHQ7IEZPTlQtRkFNSUxZOiAiVGltZXMgTmV3IFJvbWFuIjsgRk9OVC1TSVpFOiAx MC41cHQNCn0NCkRJVi5Nc29Ob3JtYWwgew0KCVRFWFQtSlVTVElGWTogaW50ZXItaWRlb2dyYXBo OyBURVhULUFMSUdOOiBqdXN0aWZ5OyBNQVJHSU46IDBjbSAwY20gMHB0OyBGT05ULUZBTUlMWTog IlRpbWVzIE5ldyBSb21hbiI7IEZPTlQtU0laRTogMTAuNXB0DQp9DQpBOmxpbmsgew0KCUNPTE9S OiBibHVlOyBURVhULURFQ09SQVRJT046IHVuZGVybGluZQ0KfQ0KU1BBTi5Nc29IeXBlcmxpbmsg ew0KCUNPTE9SOiBibHVlOyBURVhULURFQ09SQVRJT046IHVuZGVybGluZQ0KfQ0KQTp2aXNpdGVk IHsNCglDT0xPUjogcHVycGxlOyBURVhULURFQ09SQVRJT046IHVuZGVybGluZQ0KfQ0KU1BBTi5N c29IeXBlcmxpbmtGb2xsb3dlZCB7DQoJQ09MT1I6IHB1cnBsZTsgVEVYVC1ERUNPUkFUSU9OOiB1 bmRlcmxpbmUNCn0NClNQQU4uRW1haWxTdHlsZTE3IHsNCglGT05ULVNUWUxFOiBub3JtYWw7IEZP TlQtRkFNSUxZOiBWZXJkYW5hOyBDT0xPUjogd2luZG93dGV4dDsgRk9OVC1XRUlHSFQ6IG5vcm1h bDsgVEVYVC1ERUNPUkFUSU9OOiBub25lOyBtc28tc3R5bGUtdHlwZTogcGVyc29uYWwtY29tcG9z ZQ0KfQ0KRElWLlNlY3Rpb24xIHsNCglwYWdlOiBTZWN0aW9uMQ0KfQ0KVU5LTk9XTiB7DQoJRk9O VC1TSVpFOiAxMHB0DQp9DQpCTE9DS1FVT1RFIHsNCglNQVJHSU4tVE9QOiAwcHg7IE1BUkdJTi1C T1RUT006IDBweDsgTUFSR0lOLUxFRlQ6IDJlbQ0KfQ0KT0wgew0KCU1BUkdJTi1UT1A6IDBweDsg TUFSR0lOLUJPVFRPTTogMHB4DQp9DQpVTCB7DQoJTUFSR0lOLVRPUDogMHB4OyBNQVJHSU4tQk9U VE9NOiAwcHgNCn0NCjwvU1RZTEU+DQo8L0hFQUQ+DQo8Qk9EWSBzdHlsZT0iTUFSR0lOOiAxMHB4 OyBGT05ULUZBTUlMWTogdmVyZGFuYTsgRk9OVC1TSVpFOiAxMHB0Ij4NCjxESVY+PEZPTlQgY29s b3I9IzAwMDA4MCBzaXplPTIgZmFjZT1WZXJkYW5hPnNvcnJ5LCB0aW1lb3V0IGlzIDE1IA0Kc2Vj b25kczwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgY29sb3I9IzAwMDA4MCBzaXplPTIgZmFjZT1W ZXJkYW5hPjwvRk9OVD4mbmJzcDs8L0RJVj4NCjxESVY+PEZPTlQgY29sb3I9IzAwMDA4MCBzaXpl PTIgZmFjZT1WZXJkYW5hPjwvRk9OVD4mbmJzcDs8L0RJVj4NCjxESVY+PEZPTlQgY29sb3I9I2Mw YzBjMCBzaXplPTIgZmFjZT1WZXJkYW5hPjIwMTEtMTItMDkgPC9GT05UPjwvRElWPjxGT05UIA0K Y29sb3I9IzAwMDA4MCBzaXplPTIgZmFjZT1WZXJkYW5hPg0KPEhSIHN0eWxlPSJXSURUSDogMTAw cHgiIGFsaWduPWxlZnQgY29sb3I9I2I1YzRkZiBTSVpFPTE+DQo8L0ZPTlQ+DQo8RElWPjxGT05U IGNvbG9yPSNjMGMwYzAgc2l6ZT0yIGZhY2U9VmVyZGFuYT48U1BBTj5mZW5nLnpob3U8L1NQQU4+ IA0KPC9GT05UPjwvRElWPg0KPEhSIGNvbG9yPSNiNWM0ZGYgU0laRT0xPg0KDQo8RElWPjxGT05U IHNpemU9MiBmYWNlPVZlcmRhbmE+PFNUUk9ORz63orz+yMujujwvU1RST05HPiBmZW5nLnpob3Ug PC9GT05UPjwvRElWPg0KPERJVj48Rk9OVCBzaXplPTIgZmFjZT1WZXJkYW5hPjxTVFJPTkc+t6LL zcqxvOSjujwvU1RST05HPiAyMDExLTEyLTA5Jm5ic3A7IDA5OjI1OjQ5IA0KPC9GT05UPjwvRElW Pg0KPERJVj48Rk9OVCBzaXplPTIgZmFjZT1WZXJkYW5hPjxTVFJPTkc+ytW8/sjLo7o8L1NUUk9O Rz4gcGdzcWwtc3FsIDwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgc2l6ZT0yIGZhY2U9VmVyZGFu YT48U1RST05HPrOty82jujwvU1RST05HPiA8L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIHNpemU9 MiBmYWNlPVZlcmRhbmE+PFNUUk9ORz7W98zio7o8L1NUUk9ORz4gW1NRTF0gUXVlcnkgVGltZW91 dCBRdWVzdGlvbiANCjwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgc2l6ZT0yIGZhY2U9VmVyZGFu YT48L0ZPTlQ+IDwvRElWPg0KPERJVj48Rk9OVCBzaXplPTIgZmFjZT1WZXJkYW5hPg0KPERJVj48 Rk9OVCBzaXplPTIgZmFjZT1WZXJkYW5hPkhpPC9GT05UPjwvRElWPg0KPERJViBzdHlsZT0iVEVY VC1JTkRFTlQ6IDJlbSI+SSBzZXQgcXVlcnkgdGltZW91dCBpbiBjb2RlIGJ5IHVzaW5nIA0KU1FM U2V0U3RtdEF0dHIgT0RCQyBBUEkgLjwvRElWPg0KPERJViBzdHlsZT0iVEVYVC1JTkRFTlQ6IDJl bSI+Jm5ic3A7PC9ESVY+DQo8RElWIA0Kc3R5bGU9IlRFWFQtSU5ERU5UOiAyZW0iPlNRTFNldFN0 bXRBdHRyKCZuYnNwO1N0YXRlbWVudEhhbmRsZSwmbmJzcDtTUUxfQVRUUl9RVUVSWV9USU1FT1VU LCZuYnNwOyhTUUxQT0lOVEVSKXRpbWVvdXQsJm5ic3A7MCZuYnNwOykgDQo7PC9ESVY+DQo8RElW IHN0eWxlPSJURVhULUlOREVOVDogMmVtIj5TUUxFeGVjdXRlKFN0YXRlbWVudEhhbmRsZSk7PC9E SVY+DQo8RElWIHN0eWxlPSJURVhULUlOREVOVDogMmVtIj4mbmJzcDs8L0RJVj4NCjxESVYgc3R5 bGU9IlRFWFQtSU5ERU5UOiAyZW0iPkJ1dCBJIGZpbmQgdGhpcyBzZXR0aW5nJm5ic3A7aGFzIA0K bm8mbmJzcDtlZmZlY3QuQmVmb3JlIGFkZGluZyB0aW1lb3V0IHNldHRpbmcsIFNRTEV4ZWN1dGUg Y29zdHMgNDcgc2Vjb25kcy5BZnRlciANCmFkZGluZyB0aW1lb3V0LCBjb3N0aW5nIHRpbWUgaXMg c2FtZS48L0RJVj4NCjxESVYgc3R5bGU9IlRFWFQtSU5ERU5UOiAyZW0iPlBvc3RncmVzIFNRTCB2 ZXJzaW9uIDguNC4yLCBPREJDIGRyaXZlciANCjguNC4yPC9ESVY+DQo8RElWPjxGT05UIHNpemU9 MiBmYWNlPVZlcmRhbmE+PC9GT05UPiZuYnNwOzwvRElWPg0KPERJViBhbGlnbj1sZWZ0PjxGT05U IGNvbG9yPSNjMGMwYzAgc2l6ZT0yIGZhY2U9VmVyZGFuYT4yMDExLTEyLTA5IA0KPC9GT05UPjwv RElWPjxGT05UIHNpemU9MiBmYWNlPVZlcmRhbmE+DQo8SFIgc3R5bGU9IldJRFRIOiAxMjJweDsg SEVJR0hUOiAycHgiIGFsaWduPWxlZnQgU0laRT0yPg0KDQo8RElWPjxGT05UIGNvbG9yPSNjMGMw YzAgc2l6ZT0yIGZhY2U9VmVyZGFuYT48U1BBTj5mZW5nLnpob3U8L1NQQU4+IA0KPC9GT05UPjwv RElWPjwvRk9OVD48L0ZPTlQ+PC9ESVY+PC9CT0RZPjwvSFRNTD4NCg== --=====003_Dragon215355750277_=====--