Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dQClP-00013A-LA for pgsql-performance@arkaria.postgresql.org; Wed, 28 Jun 2017 13:12:12 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dQClP-0000pJ-7t for pgsql-performance@arkaria.postgresql.org; Wed, 28 Jun 2017 13:12:11 +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.84_2) (envelope-from ) id 1dQCjc-000576-LB for pgsql-performance@postgresql.org; Wed, 28 Jun 2017 13:10:21 +0000 Received: from mail-by2nam01on0106.outbound.protection.outlook.com ([104.47.34.106] helo=NAM01-BY2-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dQCjZ-0004Zh-8p for pgsql-performance@postgresql.org; Wed, 28 Jun 2017 13:10:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=infor.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=EEscsoEbGy6uoqmzLyhcohUVhPuldgRqxKsNZzsk9y8=; b=OcKjuF18sGGAyyXt9WzJow4cwEEwwxMv8VnB3pP03QgVbyzIxzAAlbdUTjcFFiPjbpRfl1T6PdFinus44SZaOgkOSFRHfjs7JtBMCZWDnt3221sPLFNjn/zEBS7xLRDR7GweMkARoDNJvum1K8gAlVn5Upw5JaTqBPOOcJpDqMY= Received: from CY1PR0201MB1897.namprd02.prod.outlook.com (10.163.56.19) by CY1PR0201MB1897.namprd02.prod.outlook.com (10.163.56.19) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256) id 15.1.1220.11; Wed, 28 Jun 2017 13:10:14 +0000 Received: from CY1PR0201MB1897.namprd02.prod.outlook.com ([10.163.56.19]) by CY1PR0201MB1897.namprd02.prod.outlook.com ([10.163.56.19]) with mapi id 15.01.1220.014; Wed, 28 Jun 2017 13:10:14 +0000 From: Brad DeJong To: Pavel Stehule , Yevhenii Kurtov CC: "pgsql-performance@postgresql.org" Subject: Re: Thread-Index: AQHS7+KeDSmh+IxdTEyHeLX1ZucTUKI6LiLw Date: Wed, 28 Jun 2017 13:10:13 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: gmail.com; dkim=none (message not signed) header.d=none;gmail.com; dmarc=none action=none header.from=infor.com; x-originating-ip: [208.92.248.6] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;CY1PR0201MB1897;7:AgylpOZFx0y8lri+YjSRDCTpb14yrSRXZhV7gMNlL0OglevksSarEMKnzJmGwH2s10XMD3TSBT2pFmjL1NeRwNzQhgleshNFUP+SjAFFlYKs36oI04JhLOqkAB6+woeAo+Ip8qA/UQzbfS8Ug/f7Miw7EBaRvJwPc3zlEgYD4PuMP33t8y/L+wv9m7PfRRfuFVebHtPsNn985eCtjOmVkiWbeSQlU4A5xrNyM43G17m1Pd8FFmhC4KW8vt7ogw33UlqF8CreFPhxnBQbgTvI2M9BIC6PfasZJJMfcNK5XkHDqMdEpf3aj6vSMzgo+ytJxNn4JN8BqiZ2nv9Pxt2ggZwnuIAOpSUjKwqVPiCiBRTXX1vMlY4E0WvFQJiEbPzLXodhVMueNCIfNVOpPXp6r7a28tbROW/Spk4X9ZPTWHBkL+nwYMEbeV35FqtHdxB8xPdFJ0lbQqNF/JTJs7LdQ+iER0l9F273IPGFjnho+HKublo3wZupnY2gfO0bTDsRyzKtwJhosWYwVVAZXz+4v7etc3Zqvl+W/DX4m8HHBr4VApBCx9VFJUgsnufYzzT1upK0KJRDN88Lh2oXmlsaipbwB2BoJ01DJqh+sNjpTn/L1AVfV4BfVbZouLxT3GRTDOSttx5LVcz/ItJ2p+KsUCptH0SVKdWfWcHe7LyGNMwiXuY+6xCahxW55DvQIdG5aWdFgDf/L5WhFMAPazyw1wd2enHW7Pj9zxlQGB9Vwl2buD2qDVlk84qZz74aWKSCudMSTiN1aXiVcV1xFJKA23Gut+Cewi7SPN9a81qRvxs= x-ms-office365-filtering-correlation-id: eab10068-8fa2-45d2-7712-08d4be2703ac x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(300000500095)(300135000095)(300000501095)(300135300095)(22001)(300000502095)(300135100095)(2017030254075)(300000503095)(300135400095)(201703131423075)(201703031133081)(300000504095)(300135200095)(300000505095)(300135600095)(300000506094)(300135500095);SRVR:CY1PR0201MB1897; x-ms-traffictypediagnostic: CY1PR0201MB1897: x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:(236129657087228)(788757137089)(48057245064654)(167848164394848)(247924648384137); x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(100000700101)(100105000095)(100000701101)(100105300095)(100000702101)(100105100095)(6040450)(601004)(2401047)(5005006)(8121501046)(3002001)(100000703101)(100105400095)(10201501046)(93006095)(93001095)(6041248)(20161123564025)(20161123558100)(20161123555025)(201703131423075)(201702281528075)(201703061421075)(201703061406153)(20161123562025)(20161123560025)(6072148)(100000704101)(100105200095)(100000705101)(100105500095);SRVR:CY1PR0201MB1897;BCL:0;PCL:0;RULEID:(100000800101)(100110000095)(100000801101)(100110300095)(100000802101)(100110100095)(100000803101)(100110400095)(100000804101)(100110200095)(100000805101)(100110500095);SRVR:CY1PR0201MB1897; x-forefront-prvs: 03524FBD26 x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(6009001)(39840400002)(39450400003)(39410400002)(39400400002)(39850400002)(377424004)(66066001)(189998001)(229853002)(221173001)(6506006)(81156014)(8676002)(81166006)(33656002)(6436002)(72206003)(93886004)(14454004)(25786009)(86362001)(2900100001)(7736002)(6246003)(74316002)(53936002)(305945005)(76176999)(54356999)(2950100002)(478600001)(4326008)(50986999)(77096006)(7696004)(7116003)(5660300001)(55016002)(99286003)(102836003)(6116002)(8936002)(3846002)(2906002)(3480700004)(9686003)(38730400002)(39060400002)(4000700002)(3280700002)(3660700001)(231573002);DIR:OUT;SFP:1102;SCL:1;SRVR:CY1PR0201MB1897;H:CY1PR0201MB1897.namprd02.prod.outlook.com;FPR:;SPF:None;MLV:ovrnspm;PTR:InfoNoRecords;LANG:en; spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: infor.com X-MS-Exchange-CrossTenant-originalarrivaltime: 28 Jun 2017 13:10:13.7836 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 457d5685-0467-4d05-b23b-8f817adda47c X-MS-Exchange-Transport-CrossTenantHeadersStamped: CY1PR0201MB1897 List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org DQoNCk9uIDIwMTctMDYtMjgsIFBhdmVsIFN0ZWh1bGUgd3JvdGUgLi4uDQo+ IE9uIDIwMTctMDYtMjgsIFlldmhlbmlpIEt1cnRvdiB3cm90ZSAuLi4NCj4+ IE9uIDIwMTctMDYtMjgsIFBhdmVsIFN0ZWh1bGUgd3JvdGUgLi4uDQo+Pj4g T24gMjAxNy0wNi0yOCwgWWV2aGVuaWkgS3VydG92IHdyb3RlIC4uLg0KPj4+ PiBXZSBoYXZlIGEgcXVlcnkgdGhhdCBpcyBydW4gYWxtb3N0IGVhY2ggc2Vj b25kIGFuZCBpdCdzIHZlcnkgaW1wb3J0YW50IHRvIHNxdWVlemUgZXZlcnkg b3RoZXIgbXMgb3V0IG9mIGl0LiBUaGUgcXVlcnkgaXM6DQo+Pj4+IC4uLg0K Pj4+PiBJIGFkZGVkIGZvbGxvd2luZyBpbmRleDogQ1JFQVRFIElOREVYIE9O IGNhbXBhaWduX2pvYnMoaWQsIHN0YXR1cywgZmFpbGVkX2F0LCBzdGFydGVk X2F0LCBwcmlvcml0eSBERVNDLCB0aW1lc19mYWlsZWQpOw0KPj4+PiAuLi4N Cj4+PiBUaGVyZSBhcmUgZmV3IGlzc3VlcyANCj4+PiBhKSBwYXJhbWV0cml6 ZWQgTElNSVQNCj4+PiBiKSBjb21wbGV4IHByZWRpY2F0ZSB3aXRoIGxvdCBv ZiBPUiANCj4+PiBjKSBzbG93IGV4dGVybmFsIHNvcnQNCj4+Pg0KPj4+IGIp IHNpZ25hbGl6ZSBtYXliZSBzb21lIHN0cmFuZ2UgaW4gZGVzaWduIC4uIHRy eSB0byByZXBsYWNlICJPUiIgYnkgIlVOSU9OIiBxdWVyeQ0KPj4+IGMpIGlm IHlvdSBjYW4gYW5kIHlvdSBoYXZlIGdvb2QgZW5vdWdoIG1lbW9yeSAuLiB0 cnkgdG8gaW5jcmVhc2Ugd29ya19tZW0gLi4gbWF5YmUgMjBNQg0KPj4+DQo+ Pj4gaWYgeW91IGNoYW5nZSBxdWVyeSB0byB1bmlvbiBxdWVyaWVzLCB0aGVu IHlvdSBjYW4gdXNlIGNvbmRpdGlvbmFsIGluZGV4ZXMNCj4+Pg0KPj4+IGNy ZWF0ZSBpbmRleChpZCkgd2hlcmUgc3RhdHVzID0gMDsNCj4+PiBjcmVhdGUg aW5kZXgoZmFpbGVkX2F0KSB3aGVyZSBzdGF0dXMgPSAyOw0KPj4+IGNyZWF0 ZSBpbmRleChzdGFydGVkX2F0KSB3aGVyZSBzdGF0dXMgPSAxOw0KPj4NCj4+ IENhbiB5b3UgcGxlYXNlIGdpdmUgYSB0aXAgaG93IHRvIHJld3JpdGUgdGhl IHF1ZXJ5IHdpdGggVU5JT04gY2xhdXNlPw0KPg0KPiBTRUxFQ1QgYzAuImlk IiBGUk9NICJjYW1wYWlnbl9qb2JzIiBBUyBjMA0KPiBXSEVSRSAoKChjMC4i c3RhdHVzIiA9ICQxKSBBTkQgTk9UIChjMC4iaWQiID0gQU5ZKCQyKSkpKQ0K PiBVTklPTiBTRUxFQ1QgYzAuImlkIiBGUk9NICJjYW1wYWlnbl9qb2JzIiBB UyBjMA0KPiBXSEVSRSAoKGMwLiJzdGF0dXMiID0gJDMpIEFORCAoYzAuImZh aWxlZF9hdCIgPiAkNCkpDQo+IFVOSU9OIFNFTEVDVCBjMC4iaWQiIEZST00g ImNhbXBhaWduX2pvYnMiIEFTIGMwDQo+IFdIRVJFICgoYzAuInN0YXR1cyIg PSAkNSkgQU5EIChjMC4ic3RhcnRlZF9hdCIgPCAkNikpDQo+IE9SREVSIEJZ IGMwLiJwcmlvcml0eSIgREVTQywgYzAuInRpbWVzX2ZhaWxlZCINCj4gTElN SVQgJDcNCj4gRk9SIFVQREFURSBTS0lQIExPQ0tFRA0KDQoNCk5vcm1hbGx5 IChhdCBsZWFzdCBmb3IgZGV2ZWxvcGVycyBJJ3ZlIHdvcmtlZCB3aXRoKSwg dGhhdCBraW5kIG9mIHF1ZXJ5IHN0cnVjdHVyZSBpcyB1c2VkIHdoZW4gdGhl ICJzdGF0dXMiIHZhbHVlcyBkb24ndCBvdmVybGFwIGFuZCBkb24ndCBjaGFu Z2UgZnJvbSBxdWVyeSB0byBxdWVyeS4gSnVkZ2luZyBmcm9tIFBhdmVsJ3Mg c3VnZ2VzdGVkIGNvbmRpdGlvbmFsIGluZGV4ZXMgKGkuZS4gIndoZXJlIHN0 YXR1cyA9IDxjb25zdGFudD4iKSwgaGUgYWxzbyB0aGlua3MgdGhhdCBpcyBs aWtlbHkuDQoNCkdpdmUgdGhlIG9wdGltaXplciB0aGF0IGluZm9ybWF0aW9u IHNvIHRoYXQgaXQgY2FuIHVzZSBpdC4gQXNzdW1pbmcgJDEgPSAwIGFuZCAk MyA9IDIgYW5kICQ1ID0gMSwgc3Vic3RpdHV0ZSBsaXRlcmFscy4gU3Vic3Rp dHV0ZSBsaXRlcmFsIGZvciAkNyBpbiBsaW1pdC4gUHVzaCBvcmRlciBieSBh bmQgbGltaXQgdG8gZWFjaCBicmFuY2ggb2YgdGhlIHVuaW9uIGFsbCAob3Ig ZG9lcyBQb3N0Z3JlcyBmaWd1cmUgdGhhdCBvdXQgYXV0b21hdGljYWxseT8p IFJlcGxhY2UgdW5pb24gd2l0aCB1bmlvbiBhbGwgKG5vdCBzdXJlIGFib3V0 IFBvc3RncmVzLCBidXQgYWxsb3dzIG90aGVyIGRibXMgdG8gYXZvaWQgc29y dGluZyBhbmQgbWVyZ2luZyByZXN1bHQgc2V0cyB0byBlbGltaW5hdGUgZHVw bGljYXRlcykuIChVc2Ugb2YgVU5JT04gQUxMIGFzc3VtZXMgdGhhdCAiaWQi IGlzIHVuaXF1ZSBhY3Jvc3Mgcm93cyBhcyBpbXBsaWVkIGJ5IG9ubHkgImlk IiBiZWluZyBzZWxlY3RlZCB3aXRoIEZPUiBVUERBVEUuIElmIG11bHRpcGxl IHJvd3MgY2FuIGhhdmUgdGhlIHNhbWUgImlkIiwgdGhlbiB1c2UgVU5JT04g dG8gZWxpbWluYXRlIHRoZSBkdXBsaWNhdGVzLikNCg0KU0VMRUNUICJpZCIg RlJPTSAiY2FtcGFpZ25fam9icyIgV0hFUkUgInN0YXR1cyIgPSAwIEFORCBO T1QgImlkIiA9IEFOWSgkMSkNCiAgVU5JT04gQUxMDQpTRUxFQ1QgImlkIiBG Uk9NICJjYW1wYWlnbl9qb2JzIiBXSEVSRSAic3RhdHVzIiA9IDIgQU5EICJm YWlsZWRfYXQiID4gJDINCiAgVU5JT04gQUxMDQpTRUxFQ1QgImlkIiBGUk9N ICJjYW1wYWlnbl9qb2JzIiBXSEVSRSAic3RhdHVzIiA9IDEgQU5EICJzdGFy dGVkX2F0IiA8ICQzDQpPUkRFUiBCWSAicHJpb3JpdHkiIERFU0MsICJ0aW1l c19mYWlsZWQiDQpMSU1JVCAxMDANCkZPUiBVUERBVEUgU0tJUCBMT0NLRUQN Cg0KDQpBbm90aGVyIHRoaW5nIHRoYXQgeW91IGNvdWxkIHRyeSBpcyB0byBw dXNoIHRoZSBPUkRFUiBCWSBhbmQgTElNSVQgdG8gdGhlIGJyYW5jaGVzIG9m IHRoZSBVTklPTiAob3IgZG9lcyBQb3N0Z3JlcyBmaWd1cmUgdGhhdCBvdXQg YXV0b21hdGljYWxseT8pIGFuZCB1c2Ugc2xpZ2h0bHkgZGlmZmVyZW50IGlu ZGV4ZXMuIFRoaXMgbWF5IG5vdCBtYWtlIHNlbnNlIGZvciBhbGwgdGhlIGJy YW5jaGVzIGJ1dCBvbmUgbmljZSB0aGluZyBhYm91dCBVTklPTiBpcyB0aGF0 IGVhY2ggYnJhbmNoIGNhbiBiZSB0d2Vha2VkIGluZGVwZW5kZW50bHkuIEFs c28sIHRoZXJlIGFyZSBwcm9iYWJseSB1bm1lbnRpb25lZCBmdW5jdGlvbmFs IGRlcGVuZGVuY2llcyB0aGF0IHlvdSBjYW4gdXNlIHRvIHJlZHVjZSB0aGUg aW5kZXggc2l6ZSBhbmQvb3IgaW1wcm92ZSB5b3VyIG1hdGNoIHJhdGUuIEV4 YW1wbGUgLSBpZiBzdGF0dXMgPSAxIG1lYW5zIHRoYXQgdGhlIGNhbXBhaWdu X2pvYiBoYXMgc3RhcnRlZCBidXQgbm90IGZhaWxlZCBvciBjb21wbGV0ZWQs IHRoZW4geW91IG1heSBrbm93IHRoYXQgc3RhcnRlZF9hdCBpcyBzZXQsIGJ1 dCBmYWlsZWRfYXQgYW5kIGVuZGVkX2F0IGFyZSBudWxsLiBUaGUgPCBjb21w YXJpc29uIGluIGFuZCBvZiBpdHNlbGYgaW1wbGllcyB0aGF0IG9ubHkgcm93 cyB3aGVyZSAic3RhcnRlZF9hdCIgaXMgbm90IG51bGwgd2lsbCBtYXRjaCB0 aGUgY29uZGl0aW9uLg0KDQpTRUxFQ1QgYzAuImlkIiBGUk9NICJjYW1wYWln bl9qb2JzIiBBUyBjMCBXSEVSRSAoKChjMC4ic3RhdHVzIiA9IDApIEFORCBO T1QgKGMwLiJpZCIgPSBBTlkoJDEpKSkpIE9SREVSIEJZIGMwLiJwcmlvcml0 eSIgREVTQywgYzAuInRpbWVzX2ZhaWxlZCIgTElNSVQgMTAwDQpVTklPTiBB TEwNClNFTEVDVCBjMC4iaWQiIEZST00gImNhbXBhaWduX2pvYnMiIEFTIGMw IFdIRVJFICgoYzAuInN0YXR1cyIgPSAyKSBBTkQgKGMwLiJmYWlsZWRfYXQi ID4gJDIpKSBPUkRFUiBCWSBjMC4icHJpb3JpdHkiIERFU0MsIGMwLiJ0aW1l c19mYWlsZWQiIExJTUlUIDEwMA0KVU5JT04gQUxMDQpTRUxFQ1QgYzAuImlk IiBGUk9NICJjYW1wYWlnbl9qb2JzIiBBUyBjMCBXSEVSRSAoKGMwLiJzdGF0 dXMiID0gMSkgQU5EIChjMC4ic3RhcnRlZF9hdCIgPCAkMykpIE9SREVSIEJZ IGMwLiJwcmlvcml0eSIgREVTQywgYzAuInRpbWVzX2ZhaWxlZCIgTElNSVQg MTAwDQpPUkRFUiBCWSBjMC4icHJpb3JpdHkiIERFU0MsIGMwLiJ0aW1lc19m YWlsZWQiDQpMSU1JVCAxMDANCkZPUiBVUERBVEUgU0tJUCBMT0NLRUQNCg0K SW5jbHVkaW5nIHRoZSAicHJpb3JpdHkiLCAidGltZXNfZmFpbGVkIiBhbmQg ImlkIiBjb2x1bW5zIGluIHRoZSBpbmRleGVzIGFsb25nIHdpdGggImZhaWxl ZF9hdCIvInN0YXJ0ZWRfYXQiIGFsbG93cyB0aGUgb3B0aW1pemVyIHRvIGRv IGluZGV4IG9ubHkgc2NhbnMuIChNYXkgc3RpbGwgaGF2ZSB0byBkbyByYW5k b20gSS9PIHRvIHRoZSBkYXRhIHBhZ2UgdG8gZGV0ZXJtaW5lIHR1cGxlIHZl cnNpb24gdmlzaWJpbGl0eSBidXQgSSBkb24ndCB0aGluayB0aGF0IGNhbiBi ZSBlbGltaW5hdGVkLikNCg0KY3JlYXRlIGluZGV4IC4uLiAoInByaW9yaXR5 IiBkZXNjLCAidGltZXNfZmFpbGVkIiwgImlkIikgICAgICAgICAgICAgICB3 aGVyZSAic3RhdHVzIiA9IDA7DQpjcmVhdGUgaW5kZXggLi4uICgicHJpb3Jp dHkiIGRlc2MsICJ0aW1lc19mYWlsZWQiLCAiaWQiLCAiZmFpbGVkX2F0Iikg IHdoZXJlICJzdGF0dXMiID0gMiBhbmQgImZhaWxlZF9hdCIgaXMgbm90IG51 bGw7DQpjcmVhdGUgaW5kZXggLi4uICgicHJpb3JpdHkiIGRlc2MsICJ0aW1l c19mYWlsZWQiLCAiaWQiLCAic3RhcnRlZF9hdCIpIHdoZXJlICJzdGF0dXMi ID0gMSBhbmQgInN0YXJ0ZWRfYXQiIGlzIG5vdCBudWxsOyAtLSBhbmQgZW5k ZWRfYXQgaXMgbnVsbCBhbmQgLi4uDQoNCg0KSSdtIGFzc3VtaW5nIHRoYXQg dGhlIG9wdGltaXplciBrbm93cyB0aGF0ICJ3aGVyZSBzdGF0dXMgPSAxIGFu ZCBzdGFydGVkX2F0IDwgJDMiIGltcGxpZXMgImFuZCBzdGFydGVkX2F0IGlz IG5vdCBudWxsIiBhbmQgd2lsbCBjb25zaWRlciB0aGUgY29uZGl0aW9uYWwg aW5kZXguIElmIG5vdCwgdGhlbiB0aGUgImFuZCBzdGFydGVkX2F0IGlzIG5v dCBudWxsIiBuZWVkcyB0byBiZSBleHBsaWNpdC4NCgotLSAKU2VudCB2aWEg cGdzcWwtcGVyZm9ybWFuY2UgbWFpbGluZyBsaXN0IChwZ3NxbC1wZXJmb3Jt YW5jZUBwb3N0Z3Jlc3FsLm9yZykKVG8gbWFrZSBjaGFuZ2VzIHRvIHlvdXIg c3Vic2NyaXB0aW9uOgpodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxw cmVmL3Bnc3FsLXBlcmZvcm1hbmNlCg==