Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eBoiW-00015e-EV for pgsql-performance@arkaria.postgresql.org; Mon, 06 Nov 2017 21:14:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1eBoiV-0001WX-Vc for pgsql-performance@arkaria.postgresql.org; Mon, 06 Nov 2017 21:14:00 +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 1eBogi-0003mK-Kr for pgsql-performance@postgresql.org; Mon, 06 Nov 2017 21:12:08 +0000 Received: from mail-by2nam03on0103.outbound.protection.outlook.com ([104.47.42.103] helo=NAM03-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 1eBoge-00081S-PY for pgsql-performance@postgresql.org; Mon, 06 Nov 2017 21:12:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=AmplifyTechnologies.onmicrosoft.com; s=selector1-amplifynation-com01i; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=S1YKIh+jpLs9BrRtNEQ0Zd6S7THaJ/Rl7Rpu90Xdq0A=; b=BlldK0u+7nbw13E2IULEMjwzQ/DOUHgKymOKpeNWzytP5k+qzvJcxnOhRO+Fml2DQ9ObzbZf9Y0ERn7FTs1oC61DlpCsIcZ8UMUeeGDDtT79uOcQ1YlMF/X8VdK9FY4knMCP6CuVE56JxKNLcBvZe3EL6X3AP12ErkjAvIC2zOI= Received: from BN6PR0101MB3074.prod.exchangelabs.com (10.174.89.10) by BN6PR0101MB3075.prod.exchangelabs.com (10.174.89.11) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P256) id 15.20.197.13; Mon, 6 Nov 2017 21:12:01 +0000 Received: from BN6PR0101MB3074.prod.exchangelabs.com ([10.174.89.10]) by BN6PR0101MB3074.prod.exchangelabs.com ([10.174.89.10]) with mapi id 15.20.0197.020; Mon, 6 Nov 2017 21:12:01 +0000 From: Adam Torres To: Justin Pryzby CC: "pgsql-performance@postgresql.org" Subject: Re: Performance loss upgrading from 9.3 to 9.6 Thread-Topic: [PERFORM] Performance loss upgrading from 9.3 to 9.6 Thread-Index: AQHTVwGr6O186sf5nkO8YCSvmtdq5KMHZx4AgABypYA= Date: Mon, 6 Nov 2017 21:12:01 +0000 Message-ID: <23D1DA58-FE4A-40BB-83CA-AFEE687D99A6@amplify-nation.com> References: <68F12CAE-BFD8-4E21-8B39-AECB0C5E5A8F@contoso.com> <20171106142142.GD14205@telsasoft.com> In-Reply-To: <20171106142142.GD14205@telsasoft.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: spf=none (sender IP is ) smtp.mailfrom=atorres@amplify-nation.com; x-originating-ip: [75.40.141.120] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;BN6PR0101MB3075;6:kUXF2YXrYkJ4o7UwacGKZkqUEftW5qDxZICYLLWG0GVjqKzARnwtz83En/5MqxvZH4a16vXTwjc/ePN+m9oVL5OuJT53o/1XNvtq9a1JRaF2NRGthOkj5J1teKdPlkZVVOeRXrQdTMumnKvzk3+tHZf8/QHM2Y6dZQ+6kc7mDcrgbvHISBILfoKvvjRkCurhUIz5/k8FjflfLRVrpyOu99mpJj1FZWcDgXh/qdvSfuJ08oXZSzelVTAly3zJO4UwtS20RljTccJX6GpRWbbNTkHASm3x14MiKcmU2wC+HiACGZwxKlYWiNN2pOQ5EU8nlsSonVD1ORR5R5Cvtpr+LZefOBgMb/Afw847yHwFlgM=;5:FzZBhWftp7uX2eEF/hlZEZpcszffrNeKRW108PrSF7qxK7fhpS9JvIlcSxaFL5Q4xi0sVE6CJYhDbb0yfa1hZJN/AYaNC30e4l/b3FJdLbhPOdefMcOPq1XgIOUlvAO26VgX+PQULCbI6dwN7NegZCsTquNMTTdig2Kxlb/p9CI=;24:A0AWBn6eWqr+XGNxq3fMlM/rRhdQS/a/8uVaIXKGJj4bA63FhV2omPWPNSQsYjlG7QeK/Li1Xh+NhAp5WaudBO763HokKgvBQff+RgYpER4=;7:DN/5LcDgDwxw9gR5bOBKClzzGACyoLuKkzuZHMroCVKPRs2F7ovk1rLXZKK7m7W7y699eyDEBwKchPqhDBu89kxrxUfc7QdXZu8Kr3GIgHXQHaVL/nn2ZRytxIA9pDxc6rD+x7yktorIVWepXfcc1pBPTZyZIB//5fYuWHP8A11edOoAmJPRULq5Bwnh+1YWNpicssB9BAnbqMOn/MCrGVT3rJ/x2qswnQKdB+Rej6IG5EZ/mFjRZ+J6G2JvSOz7 x-ms-exchange-antispam-srfa-diagnostics: SSOS; x-ms-office365-filtering-correlation-id: 57acc177-91b3-4e0f-71c4-08d5255b060f x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(22001)(4534020)(4602075)(4603075)(4627115)(201702281549075)(2017052603249);SRVR:BN6PR0101MB3075; x-ms-traffictypediagnostic: BN6PR0101MB3075: x-exchange-antispam-report-test: UriScan:; x-microsoft-antispam-prvs: x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(100000700101)(100105000095)(100000701101)(100105300095)(100000702101)(100105100095)(6040450)(2401047)(5005006)(8121501046)(3002001)(10201501046)(93006095)(93001095)(100000703101)(100105400095)(3231021)(6041248)(20161123555025)(20161123558100)(2016111802025)(20161123564025)(20161123560025)(201703131423075)(201702281528075)(201703061421075)(201703061406153)(20161123562025)(6072148)(6043046)(201708071742011)(100000704101)(100105200095)(100000705101)(100105500095);SRVR:BN6PR0101MB3075;BCL:0;PCL:0;RULEID:(100000800101)(100110000095)(100000801101)(100110300095)(100000802101)(100110100095)(100000803101)(100110400095)(100000804101)(100110200095)(100000805101)(100110500095);SRVR:BN6PR0101MB3075; x-forefront-prvs: 048396AFA0 x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(979002)(6009001)(376002)(346002)(39830400002)(24454002)(199003)(51914003)(189002)(4326008)(6246003)(82746002)(6916009)(229853002)(478600001)(86362001)(77096006)(6486002)(2950100002)(3660700001)(966005)(3280700002)(6436002)(6506006)(2906002)(33656002)(189998001)(76176999)(50986999)(2900100001)(14454004)(54356999)(316002)(68736007)(101416001)(105586002)(25786009)(5660300001)(106356001)(53936002)(7736002)(66066001)(305945005)(83716003)(99286004)(8936002)(81156014)(6512007)(6306002)(36756003)(81166006)(8676002)(6116002)(102836003)(3846002)(97736004)(969003)(989001)(999001)(1009001)(1019001);DIR:OUT;SFP:1102;SCL:1;SRVR:BN6PR0101MB3075;H:BN6PR0101MB3074.prod.exchangelabs.com;FPR:;SPF:None;PTR:InfoNoRecords;A:1;MX:1;LANG:en; received-spf: None (protection.outlook.com: amplify-nation.com does not designate permitted sender hosts) spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: text/plain; charset="utf-8" Content-ID: <7DD0981525AFA6428D18C151021339A8@prod.exchangelabs.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: amplify-nation.com X-MS-Exchange-CrossTenant-Network-Message-Id: 57acc177-91b3-4e0f-71c4-08d5255b060f X-MS-Exchange-CrossTenant-originalarrivaltime: 06 Nov 2017 21:12:01.4508 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 6846dba9-cb1d-4bea-950f-3bcded6bfade X-MS-Exchange-Transport-CrossTenantHeadersStamped: BN6PR0101MB3075 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 SnVzdGluLA0KVGhhbmtzIGZvciB0aGUgcmVwbHkuDQoNCkkgY2hhbmdlZCB0 aGUgc3RhdGlzdGljcyBvbiBhdi5jdXN0b21lcl9pZCBhcyBzdWdnZXN0ZWQg YW5kIHRoZSBudW1iZXIgcmV0dXJuZWQgYnkgcGdfc3RhdHMgd2VudCBmcm9t IDIwMiwzMzMgdG8gOTA0LDA5Ny4gIFRoZXJlIGFyZSAxMS4yIG1pbGxpb24g ZGlzdGluY3QgY3VzdG9tZXJfaWRzIG9uIHRoZSAxNC44IG1pbGxpb24gdmVo aWNsZSByZWNvcmRzLiAgUmVydW5uaW5nIHRoZSBxdWVyeSBzaG93ZWQgbm8g c2lnbmlmaWNhbnQgY2hhbmdlIGluIHRpbWUgKDYyNCBzZWNvbmRzIHZzLiA2 Mzkgc2Vjb25kcykgLSBwbGFuIGlzIGF0IGh0dHBzOi8vZXhwbGFpbi5kZXBl c3ouY29tL3MvZTJmby4NCg0KSSB3ZW50IHRocm91Z2ggdGhlIHF1ZXJ5IGxv b2tpbmcgZm9yIGZpZWxkcyB1c2VkIGluIGpvaW5zIGFuZCBjb25kaXRpb25z IGFuZCBhcHBsaWVkIHRoZSBzYW1lIHN0ZXBzIHRvIDcgb3RoZXIgZmllbGRz IG92ZXIgNCBvZiB0aGUgdGFibGVzLiAgTW9zdCBuX2Rpc3RpbmN0IHZhbHVl cyBkaWQgbm90IGNoYW5nZSBtdWNoIGJ1dCB0d28gZGlkIGNoYW5nZSBmcm9t IDEuIyBtaWxsaW9uIHRvIC0xPHg8MCB3aGljaCBzZWVtcyBiZXR0ZXIgYmFz ZWQgb24gbl9kaXN0aW5jdCdzIGRlZmluaXRpb24uICBUaGlzIGltcHJvdmVk IHRoZSBxdWVyeSBhIGxpdHRsZTsgZnJvbSA2MjQgc2Vjb25kcyBkb3duIHRv IDUxMSBzZWNvbmRzLiAgVGhhdCBwbGFuIGlzIGF0IGh0dHBzOi8vZXhwbGFp bi5kZXBlc3ouY29tL3MvdGU1MC4gIFRoaXMgaXMgdGhlIHNhbWUgcXVlcnkg dGhhdCByYW4gaW4gMjcyIHNlY29uZHMgb24gOS4zIHdpdGggdGhlIHNhbWUg ZGF0YSBhbmQgcHJldmlvdXMgc3RhdGlzdGljcyBzZXR0aW5ncy4NCg0KSXQg aGFzIG5vdyBiZWVuIGRlY2lkZWQgdG8gdHJ5IHVwZ3JhZGluZyB0byA5LjQg YXMgdGhhdCBpcyB0aGUgbWluaW11bSB0byBzdXBwb3J0IERqYW5nbyAxLjEx ICh3aGljaCB3ZSBhcmUgdHJ5aW5nIHRvIHVwZ3JhZGUgYSBiYWNrZW5kIHNl cnZpY2UgdG8pLiAgVGhlIGhvcGUgaXMgd2hhdGV2ZXIgZmVhdHVyZSB3ZSBo YXZlIG5vdCBjb25maWd1cmVkIHByb3Blcmx5IGluIDkuNiBpcyBub3QgdGhl cmUgaW4gOS40Lg0KDQoNCk9uIDExLzYvMTcsIDk6MjEgQU0sICJKdXN0aW4g UHJ5emJ5IiA8cHJ5emJ5QHRlbHNhc29mdC5jb20+IHdyb3RlOg0KDQogICAg T24gTW9uLCBOb3YgMDYsIDIwMTcgYXQgMDE6MTg6MDBQTSArMDAwMCwgQWRh bSBUb3JyZXMgd3JvdGU6DQogICAgPiBHb29kIG1vcm5pbmcgYWxsLA0KICAg ID4gDQogICAgPiBXZSBoYXZlIGEgcHJvYmxlbSB3aXRoIHBlcmZvcm1hbmNl IGFmdGVyIHVwZ3JhZGluZyBmcm9tIDkuMyB0byA5LjYgd2hlcmUgY2VydGFp biBxdWVyaWVzIHRha2UgOSB0aW1lcyBsb25nZXIgdG8gcnVuLiAgT24gb3Vy IGluaXRpYWwgYXR0ZW1wdCB0byB1cGdyYWRlLCB3ZSBub3RpY2VkIHRoZSBz eXN0ZW0gYXMgYSB3aG9sZSB3YXMgdGFraW5nIGxvbmdlciB0byBydW4gdGhy b3VnaCBub3JtYWwgZGFpbHkgcHJvY2Vzc2VzLiAgVGhlIHF1ZXJ5IHdpdGgg dGhlIGxhcmdlc3QgcnVuIHRpbWUgd2FzIHBpY2tlZCB0byBhY3QgYXMgYSBt ZWFzdXJpbmcgc3RpY2suDQogICAgDQogICAgPiBodHRwczovL2V4cGxhaW4u ZGVwZXN6LmNvbS9zL3o3MXUNCiAgICA+IFBsYW5uaW5nIHRpbWU6IDguMjE4 IG1zDQogICAgPiBFeGVjdXRpb24gdGltZTogNjM5MzE5LjUyNSBtcw0KICAg ID4gDQogICAgPiBTYW1lIHF1ZXJ5IGFzIHJ1biBvbiA5LjMNCiAgICA+IGh0 dHBzOi8vZXhwbGFpbi5kZXBlc3ouY29tL3MvZ2pOMw0KICAgID4gVG90YWwg cnVudGltZTogMjcyODk3LjE1MCBtcw0KICAgIA0KICAgIEFjdHVhbGx5IGl0 IGxvb2tzIHRvIG1lIGxpa2UgYm90aCBxdWVyeSBwbGFucyBhcmUgcG9vci4u DQogICAgDQogICAgLi5iZWNhdXNlIG9mIHRoaXM6DQogICAgfCBIYXNoIEpv aW4gKGNvc3Q9ODUsMDg2LjI1Li4xNzAsMDgwLjgwIFJPV1M9NDAgd2lkdGg9 MTE1KSAoYWN0dWFsIHRpbWU9MzIuNjczLi44NC40MjcgUk9XUz0xMywzOTAg bG9vcHM9MSkNCiAgICB8ICAgIEhhc2ggQ29uZDogKGF2LmN1c3RvbWVyX2lk ID0gY2NfMS5pZCkNCiAgICANCiAgICBJZiB0aGVyZSBhcmUgYSBsYXJnZSBu dW1iZXIgb2YgZGlzdGluY3QgY3VzdG9tZXJfaWRzIChtYXliZSB3aXRoIG5l YXJseSBlcXVhbA0KICAgIGZyZXF1ZW5jaWVzKSwgaXQgbWlnaHQgaGVscCB0 bw0KICAgIEFMVEVSIFRBQkxFIGF2IEFMVEVSIGN1c3RvbWVyX2lkIFNFVCBT VEFUSVNUSUNTIDQwMA0KICAgIC4uc2FtZSBmb3IgY2NfMS5pZC4gIEFuZCBy ZS1hbmFseXplIHRob3NlIHRhYmxlcyAoYXJlIHRoZXkgbGFyZ2U/PykuDQog ICAgDQogICAgc2VlIGlmIHN0YXRpc3RpY3MgaW1wcm92ZToNCiAgICBTRUxF Q1QgKFNFTEVDVCBzdW0oeCkgRlJPTSB1bm5lc3QobW9zdF9jb21tb25fZnJl cXMpIHgpIGZyYWNfTUNWLCB0YWJsZW5hbWUsIGF0dG5hbWUsIG5fZGlzdGlu Y3QsIGFycmF5X2xlbmd0aChtb3N0X2NvbW1vbl92YWxzLDEpIG5fbWN2LA0K ICAgIEZST00gcGdfc3RhdHMgV0hFUkUgYXR0bmFtZX4nY3VzdG9tZXJzX2N1 c3RvbWVyJyBBTkQgdGFibGVuYW1lPSdpZCcgR1JPVVAgQlkgMSwyLDMsNCw1 IE9SREVSIEJZIDENCiAgICANCiAgICBHb2FsIGlzIHRvIGdldCBhdCBsZWFz dCBhbiBhY2N1cmF0ZSB2YWx1ZSBmb3Igbl9kaXN0aW5jdCAoYnV0IHByZWZl cmFibHkgYWxzbw0KICAgIHN0b3JpbmcgdGhlIG1vc3QgZnJlcXVlbnQgSURz KS4gIEkgd291bGRuJ3QgYm90aGVyIHJlLXJ1bm5pbmcgdGhlIHF1ZXJ5IHVu bGVzcw0KICAgIHlvdSBmaW5kIHRoYXQgaW5jcmVhc2luZyBzdGF0cyB0YXJn ZXQgY2F1c2VzIHRoZSBwbGFuIHRvIGNoYW5nZS4NCiAgICANCiAgICBKdXN0 aW4NCiAgICANCg0KCi0tIApTZW50IHZpYSBwZ3NxbC1wZXJmb3JtYW5jZSBt YWlsaW5nIGxpc3QgKHBnc3FsLXBlcmZvcm1hbmNlQHBvc3RncmVzcWwub3Jn KQpUbyBtYWtlIGNoYW5nZXMgdG8geW91ciBzdWJzY3JpcHRpb246Cmh0dHA6 Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHByZWYvcGdzcWwtcGVyZm9ybWFu Y2UK