Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cZlMg-0006Vq-VS for pgsql-performance@arkaria.postgresql.org; Fri, 03 Feb 2017 21:25:55 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cZlMg-0004Dy-Fs for pgsql-performance@arkaria.postgresql.org; Fri, 03 Feb 2017 21:25:54 +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 1cZlKz-0001Me-Ru for pgsql-performance@postgresql.org; Fri, 03 Feb 2017 21:24:10 +0000 Received: from tschetwerikow.v9g.de ([217.92.164.63]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cZlKw-0004Pm-5q for pgsql-performance@postgresql.org; Fri, 03 Feb 2017 21:24:08 +0000 Received: from SOLOWJOW.ELBE.local (fd72:7df7:465c:1::e) by SOLOWJOW.ELBE.local (fd72:7df7:465c:1::e) with Microsoft SMTP Server (TLS) id 15.0.1178.4; Fri, 3 Feb 2017 22:23:56 +0100 Received: from SOLOWJOW.ELBE.local ([fe80::3810:82c2:f8c1:6242]) by SOLOWJOW.ELBE.local ([fe80::3810:82c2:f8c1:6242%12]) with mapi id 15.00.1178.000; Fri, 3 Feb 2017 22:23:50 +0100 From: Titus von Boxberg To: "pgsql-performance@postgresql.org" Subject: strange and slow joining of nested views Thread-Topic: strange and slow joining of nested views Thread-Index: AdJ+Y0cgi7Q1SvmxQXOmcdXGL6ZXGA== Date: Fri, 3 Feb 2017 21:23:49 +0000 Message-ID: Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [192.168.178.7] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Pg-Spam-Score: -1.9 (-) 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 RGVhciBhbGwsDQoNCkkgZ290IHRoZSBmb2xsb3dpbmcgcHJvYmxlbSBmb3Ig d2hpY2ggSSBjb3VsZCBub3QgZmluZCBhIHNvbHV0aW9uIGJ5IHNlYXJjaGlu ZyB0aGUgYXJjaGl2ZXM6DQoNCkkgaGF2ZSBUYWJsZXMgVGEsIFRiLCBUYyB3 aXRoIHByaW1hcnkga2V5cyBhcyBiaWdzZXJpYWxzLg0KVGEgcmVmZXJlbmNl cyBUYiByZWZlcmVuY2VzIFRjLg0KTm90IGFsbCBidXQgbW9zdCByb3dzIGlu IFRhIHJlZmVyZW5jZSBleGFjdGx5IG9uZSByb3cgaW4gVGIuDQoNCkFib3Zl IHRoZSBUYWJsZXMgSSBoYXZlIHZpZXdzIFZhLCBWYiwgVmMgdGhhdCBnYXRo ZXIgc29tZSBvdGhlciBpbmZvcm1hdGlvbiBpbiBhZGRpdGlvbiB0byB0aGUg VGFibGVzIFRhLFRiLFRjLg0KVmEgb3V0cHV0cyBjb2x1bW5zIG9mIFZiIG91 dHB1dHMgY29sdW1ucyBvZiBWYy4NCmFsc28sIHNvbWUgb3RoZXIgbmVzdGVk IHNlbGVjdHMgZm9ybSBjb2x1bW5zIG9mIFZhLCBWYiwgVmMuDQoNCm15IHBy b2JsZW0gaXMgdGhlIGpvaW4gaW4gVmE6DQpJdCBiYXNpY2FsbHkgc2F5cw0K DQpTRUxFQ1QgVGEuUEssIFRhLkZLLVRiLCBUYS544oCmLCBUYS55LCBWYi54 LCBWYi55LCDigKYNCkZST00gVGEsIFZiDQpXSEVSRSBWYi5UYlBLID0gVGEu VGJGSw0KQU5EIDxzb21lcmVzdHJpY3Rpb25PblRhPg0KDQpFdmVuIGlmIEkg c2VsZWN0IGV4YWN0bHkgb25lIHJvdyBvZiBUYSB3aGljaCBhbHNvIHJlc3Vs dHMgaW4gZXhhY2x5IG9uZSByb3cgb2YgVmIgKGFuZCB0aGVuIFZjKSwNCnRo ZSBwbGFubmVyIHNlZW1zIHRvIGFsd2F5cyBjcmVhdGUgYWxsIHBvc3NpYmxl IGxpbmVzIChvZiBhIHN1YnNlbGVjdCkgaW4gVmIgYW5kIGFmdGVyd2FyZHMg ZHJvcCBhbGwNCmxpbmVzIGJ1dCBvbmUgd2hlbiBwZXJmb3JtaW5nIHRoZSBq b2luLg0KDQpXaGVuIEkgcmVwbGFjZSBWYSdzIGpvaW4gb2YgVGEgYW5kIFZi IGJ5IGRpcmVjdGx5IHBsYWNpbmcgVmIncyBTRUxFQ1QgaW4gVmENCnRoZSBw bGFubmVyIGZpbmRzIHRoYXQgaXQgbmVlZHMgb25seSBvbmUgcm93IG9mIHRo ZSBmb3JtZXIgVmIgKHdoaWNoIGlzIHRoZW4gaW5jb3Jwb3JhdGVkIGluIFZh KS4NCg0KQWxzbywgd2hlbiBJIHJlcGxhY2UgdGhlIGFib3ZlIGpvaW4gYnkg c3Vic2VsZWN0cyByZXN1bHRpbmcgaW4gYQ0KU0VMRUNUIFRhLlBLLWlkLCBU YS5GSy1UYiwgVGEueOKApiwNCihTRUxFQ1QgVmIueCBGUk9NIFZiIFdIRVJF IFZiLlRiUEsgPSBUYS5UYkZLKSBBUyB4LA0KKFNFTEVDVCBWYi55IEZST00g VmIgV0hFUkUgVmIuVGJQSyA9IFRhLlRiRkspIEFTIHkNCldIRVJFIGUuZyBU YS5QSy1pZCA9IDxzaW5nbGV2YWx1ZT4NCg0KdGhlIHBsYW5uZXIgaXMgLSBm b3IgZWFjaCBzdWJzZWxlY3QgLSBhYmxlIHRvIHBlcmZvcm0gVmIncyBvcGVy YXRpb25zIG9uIG9ubHkgdGhlIG9uZSByb3cNCnRoYXQgbWF0Y2hlcyB0aGUg Rksgb2YgVGEuDQpUaGF0IHRoZSBwbGFubmVyIHJlcGVhdHMgdGhpcyBmb3Ig ZWFjaCBvZiB0aGUgYWJvdmUgc3Vic2VsZWN0cyBvZiBWYiBpcyBhDQpkaWZm ZXJlbnQgc3Rvcnkgd2hpY2ggSSBkb24ndCB1bmRlcnN0YW5kIGVpdGhlci4N Cg0KDQpNeSBxdWVzdGlvbiBpczoNCklzIHRoZXJlIGFueSB3YXkgdG8gY29u dmluY2UgdGhlIHBsYW5uZXIgdGhhdCBpdCBtYWtlcyBzZW5zZSBmb3INCnRo ZSBWYiBqb2luZWQgd2l0aCBUYSBpbnRvIFZhIHRvIGZpcnN0IHNlbGVjdCBv bmUgcm93IG9mIFRiIGFuZCB0aGVuIHBlcmZvcm0gdGhlIHJlc3Qgb2YgVmIg b24gdGhpcyBvbmUgcm93Pw0KKEFuZCB3aHkgaXMgdGhlIHBsYW4gZm9yIHRo ZSByZWd1bGFyIGpvaW4gZm9ybSBkaWZmZXJpbmcgZnJvbSB0aGUgc3Vic2Vs ZWN0cz8pDQoNCkhlcmUgaXMgdGhlIGV4cGxhaW4sYW5hbHl6ZSBvZiBWYSdz IFNFTEVDVCB1c2luZyBmb3VyIGZhc3Qgc3Vic2VsZWN0cyBvbiBWYjoNCmh0 dHBzOi8vZXhwbGFpbi5kZXBlc3ouY29tL3MvMnRwDQoNCkhlcmUgaXMgaXQg Zm9yIHRoZSBvcmlnaW5hbCBWYSdzIFNFTEVDVCB3aXRoIHRoZSBzbG93IGpv aW4gb2YgVGEsIFZiOg0KaHR0cHM6Ly9leHBsYWluLmRlcGVzei5jb20vcy9v S1MNCg0KQlRXOiBUaGF0IHNvbWUgZXhwcmVzc2lvbnMgaW4gVmIgYXJlIHNs b3cgYW5kIGluZWZmaWNpZW50IGlzIHVuZGVyc3Rvb2QgYW5kIGNhbiBiZSBj b3JyZWN0ZWQgYnkgbWUuDQpUaGF0J3Mgd2hhdCBtYWRlIHRoaXMgcHJvYmxl bSB2aXNpYmxlIGJ1dCB0byBteSB1bmRlcnN0YW5kaW5nIHRoaXMgc2hvdWxk IG5vdCBtYXR0ZXIgZm9yIHRoZSBxdWVzdGlvbi4NCg0KQWRkaXRpb24gaW5m b3JtYXRpb246DQoiUG9zdGdyZVNRTCA5LjYuMSwgY29tcGlsZWQgYnkgVmlz dWFsIEMrKyBidWlsZCAxODAwLCA2NC1iaXQiDQpUaGUgc2FtZSBwcm9ibGVt IGV4aXN0ZWQgb24gOS4zIGJlZm9yZS4gSSB1cGRhdGVkIHRvIDkuNi4xIHRv IHNlZSBpZiBpdCBnZXRzIGJldHRlciB3aGljaCBpdCBkaWQgbm90Lg0KSGFy ZHdhcmU6DQpWTSBydW5uaW5nIFdpbmRvd3MgMTAgb3IgV1MyMDEyUjIgb24g V1MyMDEyUjIgSHlwZXJWIHJ1bm5pbmcgb24gWGVvbiBFNS0yNjAwLiBTU0Qg YnVmZmVyZWQgSEREcy4NCkkgaGF2ZSB0aGUgaW1wcmVzc2lvbiB0aGF0IHRo aXMgcHJvYmxlbSB3YXMgYXQgbGVhc3QgaW52aXNpYmxlIG9uIDguMSB3aGlj aCBJIHVzZWQgYmVmb3JlIDkuMy4NCg0KQW55IGluc2lnaHQgaXMgd2VsY29t ZS4NCkxldCBtZSBrbm93IGlmIG1vcmUgaW5mb3JtYXRpb24gaXMgbmVlZGVk IHRvIGFuYWx5emUgdGhlIHF1ZXN0aW9uLg0KDQpSZWdhcmRzLA0KVGl0dXMN Cg0KCi0tIApTZW50IHZpYSBwZ3NxbC1wZXJmb3JtYW5jZSBtYWlsaW5nIGxp c3QgKHBnc3FsLXBlcmZvcm1hbmNlQHBvc3RncmVzcWwub3JnKQpUbyBtYWtl IGNoYW5nZXMgdG8geW91ciBzdWJzY3JpcHRpb246Cmh0dHA6Ly93d3cucG9z dGdyZXNxbC5vcmcvbWFpbHByZWYvcGdzcWwtcGVyZm9ybWFuY2UK