Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dOMdU-0007CF-Ap for pgsql-performance@arkaria.postgresql.org; Fri, 23 Jun 2017 11:20:24 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dOMdT-0006gw-OZ for pgsql-performance@arkaria.postgresql.org; Fri, 23 Jun 2017 11:20:23 +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 1dOMdT-0006gd-5n for pgsql-performance@postgresql.org; Fri, 23 Jun 2017 11:20:23 +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 1dOMdQ-000715-AZ for pgsql-performance@postgresql.org; Fri, 23 Jun 2017 11:20:21 +0000 Received: from localhost (localhost [127.0.0.1]) by relay-fr112.magwien.gv.at (Postfix) with ESMTP id 0C465205E6; Fri, 23 Jun 2017 13:19:25 +0200 (CEST) X-Virus-Scanned: by amavisd-new using Sophie and ClamAV at magwien.gv.at Received: from ntex2010j.host.magwien.gv.at (ntex2010j.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 EABEE205E2; Fri, 23 Jun 2017 13:19:24 +0200 (CEST) Received: from ntex2010i.host.magwien.gv.at ([169.254.2.119]) by ntex2010j.host.magwien.gv.at ([169.254.4.24]) with mapi id 14.03.0301.000; Fri, 23 Jun 2017 13:20:14 +0200 From: Albe Laurenz To: "'Akihiko Odaki *EXTERN*'" , "pgsql-performance@postgresql.org" Subject: Re: Inappropriate inner table for nested loop join Thread-Topic: [PERFORM] Inappropriate inner table for nested loop join Thread-Index: AQHS7A5I/r1INbdaNEeuXIIDQ/v8w6IySxpw Date: Fri, 23 Jun 2017 11:20:13 +0000 Message-ID: References: <6a997766-470e-393e-3605-e55d2b41d1a9@stu.hosei.ac.jp> In-Reply-To: <6a997766-470e-393e-3605-e55d2b41d1a9@stu.hosei.ac.jp> 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 QWtpaGlrbyBPZGFraSB3cm90ZToNCj4gSSBhbSBoYXZpbmcgYSBwcm9ibGVt IHdpdGggbmVzdGVkIGxvb3Agam9pbi4NCj4gDQo+IEEgZGF0YWJhc2UgaGFz IDIgdGFibGVzOiAicG9zdHMiIGFuZCAiZm9sbG93cyIuDQo+IFRhYmxlICJw b3N0cyIgaGF2ZSB0d28gY29sdW1uczogInRpbWVzdGFtcCIgYW5kICJhY2Nv dW50Ii4NCj4gVGFibGUgImZvbGxvd3MiIGhhdmUgdHdvIGNvbHVtbnM6ICJ0 YXJnZXRfYWNjb3VudCIgYW5kICJvd25lcl9hY2NvdW50Ii4NCj4gVGhlIGRh dGFiYXNlIGFsc28gaGFzIGFuIGluZGV4IG9uICJwb3N0cyIgKCJhY2NvdW50 IiwgInRpbWVzdGFtcCIpLCBvbmUNCj4gb24gInBvc3RzIigidGltZXN0YW1w IikgYW5kIG9uICJmb2xsb3dzIiAoIm93bmVyX2FjY291bnQiLA0KPiAidGFy Z2V0X2FjY291bnQiKS4NCj4gDQo+IFRhYmxlICJwb3N0cyIgaXMgc28gYmln IGFuZCBoYXZlIDEwIG1pbGxpb24gcmVjb3Jkcy4NCj4gVGhlIG51bWJlciBv ZiBSZWNvcmRzIHdpdGggdGhlIHNhbWUgdmFsdWUgZm9yICJvd25lcl9hY2Nv dW50cyIgaW4gdGFibGUNCj4gImZvbGxvd3MiIGlzIGFib3V0IDEwMCBieSBh dmVyYWdlLg0KPiANCj4gSSBpc3N1ZSB0aGUgZm9sbG93aW5nIHF1ZXJ5Og0K PiANCj4gU0VMRUNUICJwb3N0cyIuKg0KPiAgICBGUk9NICJwb3N0cyINCj4g ICAgSk9JTiAiZm9sbG93cyIgT04gImZvbGxvd3MiLiJ0YXJnZXRfYWNjb3Vu dCIgPSAicG9zdHMiLiJhY2NvdW50Ig0KPiAgICBXSEVSRSAiZm9sbG93cyIu Im93bmVyX2FjY291bnQiID0gJDENCj4gICAgT1JERVIgQlkgInBvc3RzIi4i dGltZXN0YW1wIg0KPiAgICBMSU1JVCAxMDANCj4gDQo+IFRoYXQgcmVzdWx0 cyBpbiBhIG5lc3RlZCBsb29wIGpvaW4gd2l0aCB0YWJsZSAicG9zdHMiIGFz IHRoZSBpbm5lciBhbmQNCj4gImZvbGxvd3MiIGFzIHRoZSBvdXRlciwgd2hp Y2ggcXVlcmllZCBmb3IgZWFjaCBsb29wLiBFWFBsQUlOIEFOQUxZWkUNCj4g c2F5cyB0aGUgYWN0dWFsIG51bWJlciBvZiByb3dzIHF1ZXJpZWQgZnJvbSB0 YWJsZSAicG9zdHMiIGlzIDUwMCwwMDAuDQo+IFRoaXMgYmVoYXZpb3IgaXMg cHJvYmxlbWF0aWMuDQo+IA0KPiBGb3IgcGVyZm9ybWFuY2UsIGl0IG1heSBi ZSBiZXR0ZXIgdG8gcmV0cmlldmUgMTAwIHJlY29yZHMgam9pbmVkIHdpdGgg YQ0KPiByZWNvcmQgaW4gdGFibGUgImZvbGxvd3MiLCBhbmQgdGhlbiB0byBy ZXRyaWV2ZSB0aG9zZSB3aG9zZQ0KPiAicG9zdHMiLiJ0aW1lc3RhbXAiIGlz IGdyZWF0ZXIgdGhhbiB0aGUgb25lIG9mIGxhc3QgcmVjb3JkIHdlIGFscmVh ZHkNCj4gaGF2ZSwgb3IgMTAwIHJlY29yZHMsIGpvaW5lZCB3aXRoIGFub3Ro ZXIgcmVjb3JkIGluIHRhYmxlICJmb2xsb3dzIiwgYW5kDQo+IHNvIG9uLiBJ dCB3b3VsZCBlbmQgdXAgcXVlcnlpbmcgMTAsMDAwIHJlY29yZHMgZnJvbSB0 YWJsZSAicG9zdHMiIGF0DQo+IG1vc3QuIFRoZSBudW1iZXIgY291bGQgYmUg ZXZlbiBzbWFsbGVyIGluIHNvbWUgY2FzZXMuDQo+IA0KPiBOb3cgSSBoYXZl IHRoZXNlIHRvdWdoIHF1ZXN0aW9uczoNCj4gKiBJcyB0aGUgImlkZWFsIiBv cGVyYXRpb24gSSBzdWdnZXN0ZWQgcG9zc2libGUgZm9yIFBvc3RncmVTUUw/ DQo+ICogSWYgc28sIEkgdGhpbmsgdGhhdCBjb3VsZCBiZSBhY2hpZXZlZCBi eSBsZXR0aW5nIFBvc3RncmVTUUwgdXNlDQo+ICJmb2xsb3dzIiBhcyB0aGUg aW5uZXIgaW4gdGhlIGxvb3BzLiBIb3cgY291bGQgSSBhY2hpZXZlIHRoYXQ/ DQo+ICogSXMgdGhlcmUgYW55IG90aGVyIHdheSB0byBpbXByb3ZlIHRoZSBw ZXJmb3JtYW5jZSBvZiB0aGUgcXVlcnk/DQoNClBvc3RncmVTUUxgcyBwbGFu IGlzIHRvIHVzZSB0aGUgaW5kZXggb24gInBvc3RzIi4idGltZXN0YW1wIiB0 byBmaW5kIHRoZQ0Kcm93cyB3aXRoIHRoZSBsb3dlc3QgInRpbWVzdGFtcCIs IG1hdGNoIHdpdGggcm93cyBmcm9tICJwb3N0cyIgaW4NCmEgbmVzdGVkIGxv b3AgYW5kIHN0b3AgYXMgc29vbiBhcyBpdCBoYXMgZm91bmQgMTAwIG1hdGNo ZXMuDQoNCk5vdyBpdCBtdXN0IGJlIHRoYXQgdGhlIHJvd3MgaW4gInBvc3Rz IiB0aGF0IG1hdGNoIHdpdGggcm93cyBpbiAiZm9sbG93cyINCmhhdmUgaGln aCB2YWx1ZXMgb2YgInRpbWVzdGFtcCIuDQoNClBvc3RncmVTUUwgZG9lc24n dCBrbm93IHRoYXQsIGJlY2F1c2UgaXQgaGFzIG5vIGVzdGltYXRlcyBob3cN CnZhbHVlcyBjb3JyZWxhdGUgYWNyb3NzIHRhYmxlcywgc28gaXQgaGFzIHRv IHNjYW4gbXVjaCBtb3JlIG9mIHRoZSBpbmRleA0KdGhhbiBpdCBoYWQgZXhw ZWN0ZWQgdG8sIGFuZCB0aGUgcXVlcnkgcGVyZm9ybXMgcG9vcmx5Lg0KDQpZ b3UgY291bGQgZWl0aGVyIHRyeSB0byBkbyBzb21ldGhpbmcgbGlrZQ0KDQpT RUxFQ1QgKg0KRlJPTSAoU0VMRUNUICJwb3N0cyIuKg0KICAgICAgRlJPTSAi cG9zdHMiDQogICAgICAgICBKT0lOICJmb2xsb3dzIiBPTiAiZm9sbG93cyIu InRhcmdldF9hY2NvdW50IiA9ICJwb3N0cyIuImFjY291bnQiDQogICAgICBX SEVSRSAiZm9sbG93cyIuIm93bmVyX2FjY291bnQiID0gJDENCiAgICAgIE9G RlNFVCAwKSBxDQpPUkRFUiBCWSAicG9zdHMiLiJ0aW1lc3RhbXAiICANCkxJ TUlUIDEwMDsNCg0KT3IgeW91IGNvdWxkIGZyb3AgdGhlIGluZGV4IG9uICJw b3N0cyIuInRpbWVzdGFtcCIgYW5kIHNlZSBpZiB0aGF0IGhlbHBzLg0KDQpZ b3VycywNCkxhdXJlbnogQWxiZQ0KCi0tIApTZW50IHZpYSBwZ3NxbC1wZXJm b3JtYW5jZSBtYWlsaW5nIGxpc3QgKHBnc3FsLXBlcmZvcm1hbmNlQHBvc3Rn cmVzcWwub3JnKQpUbyBtYWtlIGNoYW5nZXMgdG8geW91ciBzdWJzY3JpcHRp b246Cmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHByZWYvcGdzcWwt cGVyZm9ybWFuY2UK