Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fx5ZU-0000h6-77 for pgsql-performance@arkaria.postgresql.org; Tue, 04 Sep 2018 07:16:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fx5ZS-0006mW-Gk for pgsql-performance@arkaria.postgresql.org; Tue, 04 Sep 2018 07:16:18 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fx5ZR-0006mP-Hz for pgsql-performance@lists.postgresql.org; Tue, 04 Sep 2018 07:16:18 +0000 Received: from m15-63.126.com ([220.181.15.63]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fx5ZM-0004Tx-V7 for pgsql-performance@postgresql.org; Tue, 04 Sep 2018 07:16:16 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=126.com; s=s110527; h=Date:From:Subject:MIME-Version:Message-ID; bh=wNEB0 iISWTAy66fDUhl5glpkwStB3Pn1K8QV2cDQmUE=; b=bfuOwSngnM/Ijydt7iBP2 VULshlEBCPFiK62PHAo1QWnzNnaOBoJMjLrZHDd3pw9/QWUB6/2xqhH5VaIti3cw 5pDg+FziuYZcKRBAoSyXgVmKCRVP/OGIEblh0G4/3S4Z6wfxrRhDRxLcpZ8ViLpn xts3+iqkiFdkfroZ/axyzE= Received: from mpokky$126.com ( [210.13.105.28] ) by ajax-webmail-wmsvr63 (Coremail) ; Tue, 4 Sep 2018 15:16:10 +0800 (CST) X-Originating-IP: [210.13.105.28] Date: Tue, 4 Sep 2018 15:16:10 +0800 (CST) From: jimmy To: m.nanda92@gmail.com, pgsql-performance@postgresql.org, guillaume.poussel@sogeti.com Cc: jeff.janes@gmail.com Subject: RE: Query is slow when run for first time; subsequent execution is fast X-Priority: 3 X-Mailer: Coremail Webmail Server Version SP_ntes V3.5 build 20160729(86883.8884) Copyright (c) 2002-2018 www.mailtech.cn 126com X-CM-CTRLDATA: 7T5DimZvb3Rlcl9odG09MTg1Nzo1Ng== Content-Type: multipart/alternative; boundary="----=_Part_114186_274720551.1536045370507" MIME-Version: 1.0 Message-ID: <261af533.7aa3.165a3704c8b.Coremail.mpokky@126.com> X-Coremail-Locale: zh_CN X-CM-TRANSID: P8qowADXHu46MY5bUTIzAQ--.50165W X-CM-SenderInfo: 5psryyb16rjloofrz/1tbigR+38VpD5+Px6AABsd X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_114186_274720551.1536045370507 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: base64 T24gd2luZG93cywgaG93IHRvIHB1dCBhbiBlbnRyeSBpbiBteSBkYiBzdGFydHVwIHNjcmlwdCB0 byBydW4gdGhpcyBxdWVyeSCjqHBnX3ByZXdhcm2jqSBpbW1lZGlhdGVseSBhZnRlciBzdGFydG5n IHRoZSBzZXJ2ZXIsIGFuZCBsZXQgdGhlIHF1ZXJ5IHdhcm0gdGhlIGNhY2hlIGl0c2VsZi4KQWZ0 ZXIgc3RhcnRpbmcgdGhlIHNlcnZlciwgSSB3YW50IHRvIGtub3cgd2hhdCBpcyAgdGhlIHNlcnZl ciwgYW5kIGl0IGlzIHRoZSBkYXRhYmFzZSBJIHJlc3RhcnRlZCBvciB3aW5kb3dzIHN5c3RlbT8K VGhhbmsgeW91LiAgCgoKPkhpLAo+T24gMTcgSmFuIDIwMTggMTI6NTUsICJQT1VTU0VMLCBHdWls bGF1bWUiIDxndWlsbGF1bWUoZG90KXBvdXNzZWwoYXQpc29nZXRpKGRvdCljb20+Cj53cm90ZToK PkFyZSB5b3Ugb24gV2luZG93cyBvciBMaW51eD8gSaGvbSBvbiBXaW5kb3dzIGFuZCB3b25kZXJp bmcgaWYgdGhlIGlzc3VlIGlzCj50aGUgc2FtZSBvbiBMaW51eD8KPkkgaGF2ZSBleHBlcmllbmNl ZCB0aGlzIG9uIE1hYyBhbmQgTGludXggbWFjaGluZXMuCj5Zb3UgY2FuIHRyeSBwZ19wcmV3YXJt LCBvbiBwZ19zdGF0aXN0aWMgdGFibGUgYW5kIGl0cyBpbmRleC4gIEJ1dCBJJ2QKPnByb2JhYmx5 IGp1c3QgcHV0IGFuIGVudHJ5IGluIG15IGRiIHN0YXJ0dXAgc2NyaXB0IHRvIHJ1biB0aGlzIHF1 ZXJ5Cj5pbW1lZGlhdGVseSBhZnRlciBzdGFydG5nIHRoZSBzZXJ2ZXIsIGFuZCBsZXQgdGhlIHF1 ZXJ5IHdhcm0gdGhlIGNhY2hlCj5pdHNlbGYuCgoKCgo+SSB3aWxsIHRyeSB0aGlzIHN1Z2dlc3Rp b24gYW5kIGdldCBiYWNrIG9uIHRoZSB0aHJlYWQuIElzIHBnX3N0YXRpc3RpYyB0aGUKPm9ubHkg dGFibGUgdG8gYmUgcHJlIGNhY2hlZD8gUGxzIGxldCBtZSBrbm93IGlmIGFueSBvdGhlciB0YWJs ZS9pbmRleCBuZWVkcwo+dG8gYmUgcHJlIHdhcm1lZC4KPgo+Cj5CdHcsIEkgZG9uJ3QgcnVubmlu ZyBhICJzZWxlY3QgKiBmcm9tIHBnX3N0YXRpc3RpYyIgd2lsbCBmaWxsIHRoZSBzaGFyZWQKPmJ1 ZmZlci4gT25seSAyNTYga2Igb2YgZGF0YSB3aWxsIGJlIGNhY2hlZCBkdXJpbmcgc2VxdWVudGlh bCBzY2Fucy4gSSB3aWxsCj50cnkgcGdfcHJld2FybQo+Cj4KPldoeSBkbyB5b3UgcmVzdGFydCB5 b3VyIGRhdGFiYXNlIG9mdGVuCj4KPgo+UG9zdGdyZXMgaXMgYnVuZGxlZCB3aXRoIG91ciBhcHBs aWNhdGlvbiBhbmQgZGVwbG95ZWQgYnkgb3VyIGNsaWVudC4KPlN0YXJ0aW5nIC8gc3RvcHBpbmcg dGhlIHNlcnZlciBpcyBub3QgdW5kZXIgbXkgY29udHJvbC4KPgo+Cj5SZWdhcmRzLAo+TmFuZGE= ------=_Part_114186_274720551.1536045370507 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0ibGluZS1oZWlnaHQ6MS43O2NvbG9yOiMwMDAwMDA7Zm9udC1zaXplOjE0cHg7 Zm9udC1mYW1pbHk6QXJpYWwiPjxkaXY+T24gd2luZG93cywgaG93IHRvIHB1dCBhbiBlbnRyeSBp biBteSBkYiBzdGFydHVwIHNjcmlwdCB0byBydW4gdGhpcyBxdWVyeSCjqHBnX3ByZXdhcm2jqSBp bW1lZGlhdGVseSBhZnRlciBzdGFydG5nIHRoZSBzZXJ2ZXIsIGFuZCBsZXQgdGhlIHF1ZXJ5IHdh cm0gdGhlIGNhY2hlIGl0c2VsZi48L2Rpdj48ZGl2PkFmdGVyIHN0YXJ0aW5nIHRoZSBzZXJ2ZXIs IEkgd2FudCB0byBrbm93IHdoYXQgaXMgJm5ic3A7dGhlIHNlcnZlciwgYW5kIGl0IGlzIHRoZSBk YXRhYmFzZSBJIHJlc3RhcnRlZCBvciB3aW5kb3dzIHN5c3RlbT88L2Rpdj48ZGl2PlRoYW5rIHlv dS4gJm5ic3A7PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj4mZ3Q7SGksPC9kaXY+PGRpdj4mZ3Q7 T24gMTcgSmFuIDIwMTggMTI6NTUsICJQT1VTU0VMLCBHdWlsbGF1bWUiICZsdDtndWlsbGF1bWUo ZG90KXBvdXNzZWwoYXQpc29nZXRpKGRvdCljb20mZ3Q7PC9kaXY+PGRpdj4mZ3Q7d3JvdGU6PC9k aXY+PGRpdj4mZ3Q7QXJlIHlvdSBvbiBXaW5kb3dzIG9yIExpbnV4PyBJoa9tIG9uIFdpbmRvd3Mg YW5kIHdvbmRlcmluZyBpZiB0aGUgaXNzdWUgaXM8L2Rpdj48ZGl2PiZndDt0aGUgc2FtZSBvbiBM aW51eD88L2Rpdj48ZGl2PiZndDtJIGhhdmUgZXhwZXJpZW5jZWQgdGhpcyBvbiBNYWMgYW5kIExp bnV4IG1hY2hpbmVzLjwvZGl2PjxkaXY+Jmd0O1lvdSBjYW4gdHJ5IHBnX3ByZXdhcm0sIG9uIHBn X3N0YXRpc3RpYyB0YWJsZSBhbmQgaXRzIGluZGV4LiAmbmJzcDtCdXQgSSdkPC9kaXY+PGRpdj4m Z3Q7cHJvYmFibHkganVzdCBwdXQgYW4gZW50cnkgaW4gbXkgZGIgc3RhcnR1cCBzY3JpcHQgdG8g cnVuIHRoaXMgcXVlcnk8L2Rpdj48ZGl2PiZndDtpbW1lZGlhdGVseSBhZnRlciBzdGFydG5nIHRo ZSBzZXJ2ZXIsIGFuZCBsZXQgdGhlIHF1ZXJ5IHdhcm0gdGhlIGNhY2hlPC9kaXY+PGRpdj4mZ3Q7 aXRzZWxmLjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+Jmd0O0kgd2ls bCB0cnkgdGhpcyBzdWdnZXN0aW9uIGFuZCBnZXQgYmFjayBvbiB0aGUgdGhyZWFkLiBJcyBwZ19z dGF0aXN0aWMgdGhlPC9kaXY+PGRpdj4mZ3Q7b25seSB0YWJsZSB0byBiZSBwcmUgY2FjaGVkPyBQ bHMgbGV0IG1lIGtub3cgaWYgYW55IG90aGVyIHRhYmxlL2luZGV4IG5lZWRzPC9kaXY+PGRpdj4m Z3Q7dG8gYmUgcHJlIHdhcm1lZC48L2Rpdj48ZGl2PiZndDs8L2Rpdj48ZGl2PiZndDs8L2Rpdj48 ZGl2PiZndDtCdHcsIEkgZG9uJ3QgcnVubmluZyBhICJzZWxlY3QgKiBmcm9tIHBnX3N0YXRpc3Rp YyIgd2lsbCBmaWxsIHRoZSBzaGFyZWQ8L2Rpdj48ZGl2PiZndDtidWZmZXIuIE9ubHkgMjU2IGti IG9mIGRhdGEgd2lsbCBiZSBjYWNoZWQgZHVyaW5nIHNlcXVlbnRpYWwgc2NhbnMuIEkgd2lsbDwv ZGl2PjxkaXY+Jmd0O3RyeSBwZ19wcmV3YXJtPC9kaXY+PGRpdj4mZ3Q7PC9kaXY+PGRpdj4mZ3Q7 PC9kaXY+PGRpdj4mZ3Q7V2h5IGRvIHlvdSByZXN0YXJ0IHlvdXIgZGF0YWJhc2Ugb2Z0ZW48L2Rp dj48ZGl2PiZndDs8L2Rpdj48ZGl2PiZndDs8L2Rpdj48ZGl2PiZndDtQb3N0Z3JlcyBpcyBidW5k bGVkIHdpdGggb3VyIGFwcGxpY2F0aW9uIGFuZCBkZXBsb3llZCBieSBvdXIgY2xpZW50LjwvZGl2 PjxkaXY+Jmd0O1N0YXJ0aW5nIC8gc3RvcHBpbmcgdGhlIHNlcnZlciBpcyBub3QgdW5kZXIgbXkg Y29udHJvbC48L2Rpdj48ZGl2PiZndDs8L2Rpdj48ZGl2PiZndDs8L2Rpdj48ZGl2PiZndDtSZWdh cmRzLDwvZGl2PjxkaXY+Jmd0O05hbmRhPC9kaXY+PC9kaXY+PGJyPjxicj48c3BhbiB0aXRsZT0i bmV0ZWFzZWZvb3RlciI+PHA+Jm5ic3A7PC9wPjwvc3Bhbj4= ------=_Part_114186_274720551.1536045370507--