Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dXimo-0007hT-KH for pgsql-performance@arkaria.postgresql.org; Wed, 19 Jul 2017 06:48:42 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dXimo-0004Kn-2S for pgsql-performance@arkaria.postgresql.org; Wed, 19 Jul 2017 06:48:42 +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 1dXil4-00019Q-9a for pgsql-performance@postgresql.org; Wed, 19 Jul 2017 06:46:54 +0000 Received: from relay-fr112.magwien.gv.at ([217.149.228.141]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dXikw-00072w-T6 for pgsql-performance@postgresql.org; Wed, 19 Jul 2017 06:46:53 +0000 Received: from localhost (localhost [127.0.0.1]) by relay-fr112.magwien.gv.at (Postfix) with ESMTP id 606B02059A; Wed, 19 Jul 2017 08:45:21 +0200 (CEST) X-Virus-Scanned: by amavisd-new using Sophie and ClamAV at magwien.gv.at Received: from ntex2010b.host.magwien.gv.at (ntex2010b.host.magwien.gv.at [--]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by relay-fr112.magwien.gv.at (Postfix) with ESMTPS id 48D32206A1; Wed, 19 Jul 2017 08:45:21 +0200 (CEST) Received: from ntex2010i.host.magwien.gv.at ([169.254.2.67]) by ntex2010b.host.magwien.gv.at ([169.254.3.153]) with mapi id 14.03.0301.000; Wed, 19 Jul 2017 08:46:43 +0200 From: Albe Laurenz To: "'fx TATEISHI KOJI *EXTERN*'" , "pgsql-performance@postgresql.org" Subject: Re: 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: AdMAMdRDeTRnqi0IQOSRX7kpo1JdtQAKIOuw Date: Wed, 19 Jul 2017 06:46:43 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US, de-AT Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 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 ZnggVEFURUlTSEkgS09KSSB3cm90ZToNCj4gSXNzdWluZyBleGFjdGx5IHRo ZSBzYW1lIHF1ZXJ5IGFzIFBvc3RncmVTUUwgOC4yLjIxIGFuZCBQb3N0Z3Jl U1FMIDkuMy4yIHdpbGwgc2xvdyB0aGUNCj4gcmVzcG9uc2UgYnkgNi40IG1z IG9uIGF2ZXJhZ2UuDQo+IFdoYXQgY291bGQgYmUgdGhlIGNhdXNlPw0KPiBN ZWFzdXJlbWVudCBtZXRob2QgaXMgYXMgZm9sbG93cy4NCj4g44O7IFBvc3Rn cmVTUUwgOC4yLjIxIGluc3RhbGxhdGlvbg0KPiAg4piFTWVhc3VyZW1lbnQN Cj4g44O7IEV4cG9ydCBEVU1QIG9mIFBvc3RncmVTUUwgOC4yLjIxDQo+IOOD uyBQb3N0Z3JlU1FMIDguMi4yMSB1bmluc3RhbGxhdGlvbg0KPiDjg7sgUG9z dGdyZVNRTCA5LjMuMiBpbnN0YWxsYXRpb24NCj4g44O7IER1bXAgaW1wb3J0 DQo+ICDimIVNZWFzdXJlbWVudA0KDQpJdCBpcyBpbXBvc3NpYmxlIHRvIGFu c3dlciB0aGlzIHdpdGggY2VydGFpbnR5IHdpdGhvdXQNCkVYUExBSU4gKEFO QUxZWkUsIEJVRkZFUlMpIG91dHB1dCwgYnV0IG15IGZpcnN0IGd1ZXNzIGlz IHRoYXQNCnRoZSBzdGF0aXN0aWNzIG9uIHRoZSA5LjMgaW5zdGFsbGF0aW9u IGFyZSBub3QgdXAgdG8gZGF0ZS4NCg0KQU5BTFlaRSBhbGwgaW52b2x2ZWQg dGFibGVzLCB0aGVuIHRyeSBhZ2FpbiBhbmQgc2VlIGlmIHRoZQ0KcGVyZm9y bWFuY2UgZGVncmFkYXRpb24gaGFzIHZhbmlzaGVkLg0KDQpJZiBub3QsIHN0 YXJ0IHN0dWR5aW5nIHRoZSBleGVjdXRpb24gcGxhbnMuDQoNCkFyZSB0aGUg cGFyYW1ldGVycyBpbiBwb3N0Z3Jlc3FsLmNvbmYgc2V0IHRoZSBzYW1lPw0K DQpZb3VycywNCkxhdXJlbnogQWxiZQ0KCi0tIApTZW50IHZpYSBwZ3NxbC1w ZXJmb3JtYW5jZSBtYWlsaW5nIGxpc3QgKHBnc3FsLXBlcmZvcm1hbmNlQHBv c3RncmVzcWwub3JnKQpUbyBtYWtlIGNoYW5nZXMgdG8geW91ciBzdWJzY3Jp cHRpb246Cmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHByZWYvcGdz cWwtcGVyZm9ybWFuY2UK