Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dXeEH-0007vJ-EA for pgsql-performance@arkaria.postgresql.org; Wed, 19 Jul 2017 01:56:46 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dXeEG-0003JY-JO for pgsql-performance@arkaria.postgresql.org; Wed, 19 Jul 2017 01:56:44 +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 1dXeCW-0000A4-2i for pgsql-performance@postgresql.org; Wed, 19 Jul 2017 01:54:56 +0000 Received: from mo1500.mxl.2iij.net ([203.180.99.16] helo=mo.mxl.2iij.net) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dXeCR-0000wT-M9 for pgsql-performance@postgresql.org; Wed, 19 Jul 2017 01:54:54 +0000 Received: by mo.mxl.2iij.net (mxl-mo1500) id v6J1slu0010628; Wed, 19 Jul 2017 10:54:47 +0900 Received: from unknown [210.173.21.247] (EHLO kysosm.fujixerox.co.jp) by mas1501a.mxl.2iij.net(mxl_mta-7.2.4-7) over TLS secured channel with ESMTP id 7ebbe695.0.99535.00-697.172060.mas1501a.mxl.2iij.net (envelope-from ); Wed, 19 Jul 2017 10:54:47 +0900 (JST) X-MXL-Hash: 596ebbe76f6bc43f-baecd02ff32aa226c957631d3aec90febce75277 Received: from mx01.fujixerox.co.jp ([129.249.131.203]) by kysosm.fujixerox.co.jp with ESMTP id v6J1slke007554 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Wed, 19 Jul 2017 10:54:47 +0900 Received: from APC01-PU1-obe.outbound.protection.outlook.com ([65.55.88.20]) by mx01.fujixerox.co.jp with ESMTP id v6J1skDi032650 for ; Wed, 19 Jul 2017 10:54:46 +0900 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=allfujixerox.onmicrosoft.com; s=selector1-fujixerox-co-jp; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=+L+unJ9QgUUwEfJYieagDr6AdhUyPsO6+Q2gbzLMk44=; b=djRRP8X2sCXUixGw/59ld4bXEclsv5L9WETK2dYaB/7LYWA3I1UbmtBQN/7Fj6Av20nxsSgHlaTK+WODiRuC8OtO5JCRJBJI1MUQTUnlYadEegdJmQjAeXNlE75whSlzVIvt+cmjRyibR+tCy6py0GuoC9uayadT6XNV8jQzZDI= Received: from SINPR0601MB1806.apcprd06.prod.outlook.com (10.242.56.20) by SINPR0601MB1805.apcprd06.prod.outlook.com (10.242.56.19) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256) id 15.1.1261.13; Wed, 19 Jul 2017 01:54:46 +0000 Received: from SINPR0601MB1806.apcprd06.prod.outlook.com ([fe80::797f:a44e:bd82:4713]) by SINPR0601MB1806.apcprd06.prod.outlook.com ([fe80::797f:a44e:bd82:4713%15]) with mapi id 15.01.1261.024; Wed, 19 Jul 2017 01:54:46 +0000 From: fx TATEISHI KOJI To: "pgsql-performance@postgresql.org" Subject: Performance degradation from PostgreSQL 8.2.21 to PostgreSQL 9.3.2 Thread-Topic: Performance degradation from PostgreSQL 8.2.21 to PostgreSQL 9.3.2 Thread-Index: AdMAMdRDeTRnqi0IQOSRX7kpo1JdtQ== Date: Wed, 19 Jul 2017 01:54:46 +0000 Message-ID: Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [210.173.20.91] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;SINPR0601MB1805;7:M/kmCR5Ux9dluc62zEv1HVEDJbCOxRP+75tR4xBZsy011nHblkMh72VBuG9b/7bmnlIf0sN3dt29uM5iZMaab6F+DNx4Ra/yGzZCrdY3mZVQIdl4x44jXvK0qE9TkZWFquIvZzeSSYitqvvhw5LdUAdaIU13NnTlEnpUa+MGAOqpe1B7t/DF1Jya29GkI6LOMHbwVDl2f5hwErOFik+IRXszWT8PdOqUBCR3ztsHke2sTQk3PnRYbvZkdc6VGzq1qzjKRa8wQ4SDdR8PC6m86f6IHG/JUXjMjOOAB5MbK/2pMfhey5KfRR4JbaiFOFPrEzF3xUBYaSpWvSVW0Y5GPhznZKOCXxyVZQC5Rx+osFBJJ/buSrP9BsuEzXw2G7Lta5jBllzIomKPtV0/3ueBrBHVMmd2n+hrwdOmuQWYoK9xWg0TJ4oqK4v+Yz637FWC8sAyo9V7Uhq2l08LtrxDzH9S1QPgUz/4fbqgN87pxGP3pbjzBKLwT8n2VXvzUUaScFR6q5huiHneynoM0g1SforF/++MyHJL1HPaL6qC8LuQf38R+2QMCNuTEF0n6YOFkbeCIaTfyZQyKsXRQqOXMkHF2zx1vwyaIc2xVZ6FZ9T/0Qj8J1YJET1cKEd4EuWWZJpe0kSG9GY88HuPmXyOKh4/7+nowNV3rIQSTimWdeUCtaoufgK7b8HtaTSrDZ233X3kwe66poeX/ujYMj/sJMkDZ26TUz/mus7WLum4yddUM5QC8NUKRnkLE9McH+TgElT3Rpwj6pSfNOALcPWMLmoAsnmehIy0CHATIsj1kos= x-ms-office365-filtering-correlation-id: bde6fe14-b847-4f00-2f7a-08d4ce4921e0 x-ms-office365-filtering-ht: Tenant x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(300000500095)(300135000095)(300000501095)(300135300095)(22001)(300000502095)(300135100095)(2017030254075)(48565401081)(300000503095)(300135400095)(2017052603031)(201703131423075)(201703031133081)(300000504095)(300135200095)(300000505095)(300135600095)(300000506095)(300135500095);SRVR:SINPR0601MB1805; x-ms-traffictypediagnostic: SINPR0601MB1805: x-exchange-antispam-report-test: UriScan:(236129657087228); x-microsoft-antispam-prvs: x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(100000700101)(100105000095)(100000701101)(100105300095)(100000702101)(100105100095)(6040450)(601004)(2401047)(5005006)(8121501046)(2017060910075)(93006095)(93001095)(100000703101)(100105400095)(10201501046)(3002001)(6055026)(6041248)(20161123560025)(20161123564025)(20161123555025)(20161123562025)(201703131423075)(201703011903075)(201702281528075)(201703061421075)(20161123558100)(6072148)(100000704101)(100105200095)(100000705101)(100105500095);SRVR:SINPR0601MB1805;BCL:0;PCL:0;RULEID:(100000800101)(100110000095)(100000801101)(100110300095)(100000802101)(100110100095)(100000803101)(100110400095)(100000804101)(100110200095)(100000805101)(100110500095);SRVR:SINPR0601MB1805; x-forefront-prvs: 0373D94D15 x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(6009001)(39400400002)(39410400002)(39840400002)(39850400002)(39860400002)(39450400003)(5423002)(3280700002)(2906002)(55016002)(99286003)(9686003)(5640700003)(110136004)(189998001)(66066001)(53936002)(508600001)(3660700001)(54356999)(50986999)(38730400002)(25786009)(2351001)(33656002)(5660300001)(74316002)(14454004)(6116002)(6436002)(74482002)(6506006)(7696004)(8936002)(305945005)(42882006)(7736002)(2501003)(2900100001)(102836003)(86362001)(3846002)(81166006)(5250100002)(6916009)(8676002);DIR:OUT;SFP:1102;SCL:1;SRVR:SINPR0601MB1805;H:SINPR0601MB1806.apcprd06.prod.outlook.com;FPR:;SPF:None;MLV:sfv;LANG:en; spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginatorOrg: fujixerox.co.jp X-MS-Exchange-CrossTenant-originalarrivaltime: 19 Jul 2017 01:54:46.0326 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 176c9cc7-bcae-4c9a-9d8f-1b9322aff6ab X-MS-Exchange-Transport-CrossTenantHeadersStamped: SINPR0601MB1805 X-MAIL-FROM: X-SOURCE-IP: [210.173.21.247] X-Spam: exempt 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 Issuing exactly the same query as PostgreSQL 8.2.21 and PostgreSQL 9.3.2 wi= ll slow the response by 6.4 ms on average. What could be the cause? Measurement method is as follows. =1B$B!&=1B(B PostgreSQL 8.2.21 installation =1B$B!z=1B(BMeasurement =1B$B!&=1B(B Export DUMP of PostgreSQL 8.2.21 =1B$B!&=1B(B PostgreSQL 8.2.21 uninstallation =1B$B!&=1B(B PostgreSQL 9.3.2 installation =1B$B!&=1B(B Dump import =1B$B!z=1B(BMeasurement [query] select table4.a as col_0_0_, table4.a as col_1_0_, table4.a as col_2_0_, table4.b as col_0_1_, table4.c, table4.d from table1, table2, table3, table4=20 where table1.a=3Dtable2.a and table1.a=3D"parameter$1" and table2.roleid=3Dtable3.roleid and table3.a=3D"parameter$2" and table4.b=3D'3' and table2.a=3Dtable4.a; --=20 Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance