Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dPPpM-0005D4-Qq for pgsql-performance@arkaria.postgresql.org; Mon, 26 Jun 2017 08:57: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 1dPPpM-00050R-98 for pgsql-performance@arkaria.postgresql.org; Mon, 26 Jun 2017 08:57: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 1dPPnY-0001pV-RH for pgsql-performance@postgresql.org; Mon, 26 Jun 2017 08:55:08 +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 1dPPnV-0006Nc-UU for pgsql-performance@postgresql.org; Mon, 26 Jun 2017 08:55:07 +0000 Received: from localhost (localhost [127.0.0.1]) by relay-fr112.magwien.gv.at (Postfix) with ESMTP id 5FC32205D3; Mon, 26 Jun 2017 10:54:05 +0200 (CEST) X-Virus-Scanned: by amavisd-new using Sophie and ClamAV at magwien.gv.at Received: from ntex2010a.host.magwien.gv.at (ntex2010a.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 49B3E2051C; Mon, 26 Jun 2017 10:54:04 +0200 (CEST) Received: from ntex2010i.host.magwien.gv.at ([169.254.2.119]) by ntex2010a.host.magwien.gv.at ([169.254.1.47]) with mapi id 14.03.0301.000; Mon, 26 Jun 2017 10:55:00 +0200 From: Albe Laurenz To: "'Akihiko Odaki *EXTERN*'" CC: "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///lOYCAAAUFgIAEpSdA Date: Mon, 26 Jun 2017 08:55:00 +0000 Message-ID: References: <6a997766-470e-393e-3605-e55d2b41d1a9@stu.hosei.ac.jp> <4b3fe214-6756-26d1-82d2-1882f7418033@stu.hosei.ac.jp> <81a17ec0-4556-8d41-e043-777433d8ba10@stu.hosei.ac.jp> In-Reply-To: <81a17ec0-4556-8d41-e043-777433d8ba10@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 QWtpaGlrbyBPZGFraSB3cm90ZToNCj4gT24gMjAxNy0wNi0yMyAyMDoyMCwg QWxiZSBMYXVyZW56IHdyb3RlOg0KPj4gWW91IGNvdWxkIGVpdGhlciB0cnkg dG8gZG8gc29tZXRoaW5nIGxpa2UNCj4+DQo+PiBTRUxFQ1QgKg0KPj4gRlJP TSAoU0VMRUNUICJwb3N0cyIuKg0KPj4gICAgICAgIEZST00gInBvc3RzIg0K Pj4gICAgICAgICAgIEpPSU4gImZvbGxvd3MiIE9OICJmb2xsb3dzIi4idGFy Z2V0X2FjY291bnQiID0gInBvc3RzIi4iYWNjb3VudCINCj4+ICAgICAgICBX SEVSRSAiZm9sbG93cyIuIm93bmVyX2FjY291bnQiID0gJDENCj4+ICAgICAg ICBPRkZTRVQgMCkgcQ0KPj4gT1JERVIgQlkgInBvc3RzIi4idGltZXN0YW1w Ig0KPj4gTElNSVQgMTAwOw0KPiANCj4gTm93IEkgd29uZGVyIHdoZXRoZXIg aXQgYWN0dWFsbHkgc29ydGVkIG9yIG5vdC4gQXMgeW91IHNhaWQsIEkgd2Fu dCB0bw0KPiAiZmluZCByb3dzIHdpdGggdGhlIGdyZWF0ZXN0ICd0aW1lc3Rh bXAnLCBtYXRjaCB3aXRoIHJvd3MgZnJvbSAncG9zdHMnDQo+IGluIGEgbmVz dGVkIGxvb3AgYW5kIHN0b3AgYXMgc29vbiBhcyBpdCBoYXMgZm91bmQgMTAw IG1hdGNoZXMiLg0KPiANCj4gSG93ZXZlciwgaXQgc2VlbXMgdG8gcXVlcnkg MTAwIHJlY29yZHMgd2l0aG91dCBhbnkgY29uc2lkZXJhdGlvbiBmb3INCj4g InRpbWVzdGFtcCIsIGFuZCB0aGVuIHNvcnRzIHRoZW0uIFRoYXQgaXMgbm90 IGV4cGVjdGVkLiBIZXJlIGlzIGENCj4gYWJzdHJhY3QgcXVlcnkgcGxhbjoN Cj4gDQo+ICAgTGltaXQNCj4gICAgIC0+ICBTb3J0DQo+ICAgICAgICAgICBT b3J0IEtleTogcG9zdHMuaWQgREVTQw0KPiAgICAgICAgICAgLT4gIE5lc3Rl ZCBMb29wDQo+ICAgICAgICAgICAgICAgICAtPiAgU2VxIFNjYW4gb24gZm9s bG93cw0KPiAgICAgICAgICAgICAgICAgICAgICAgRmlsdGVyOiAob3duZXJf YWNjb3VudCA9ICQxKQ0KPiAgICAgICAgICAgICAgICAgLT4gIEluZGV4IFNj YW4gdXNpbmcgaW5kZXhfcG9zdHNfb25fYWNjb3VudCBvbiBwb3N0cw0KPiAg ICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKGFjY291bnRfaWQg PSBmb2xsb3dzLnRhcmdldF9hY2NvdW50KQ0KPiANCj4gaW5kZXhfcG9zdHNf b25fYWNjb3VudCBpcyBhbiBvYnNvbGV0ZSBpbmRleCBvbiAicG9zdHMiIGFu ZCBvbmx5IGZvcg0KPiAiYWNjb3VudCIuIFNvIGl0IGRvZXMgbm90aGluZyBm b3Igc29ydGluZyAidGltZXN0YW1wIi4NCg0KVGhhdCBzaG91bGQgYmUgZmlu ZS4NCg0KSXQgZmV0Y2hlcyBhbGwgcm93cyBmcm9tICJmb2xsb3dzIiB0aGF0 IG1hdGNoIHRoZSBjb25kaXRpb24sDQpUaGVuIGpvaW5zIHRoZW0gd2lsbCBh bGwgbWF0Y2hpbmcgcm93cyBmcm9tICJwb3N0cyIsIHNvcnRzIHRoZQ0KcmVz dWx0IGRlc2NlbmRpbmcgYnkgImlkIiBhbmQgcmV0dXJucyB0aGUgMTAwIHJv d3Mgd2l0aCB0aGUgbGFyZ2VzdA0KdmFsdWUgZm9yICJpZCIuDQoNClNvIHlv dSB3aWxsIGdldCB0aG9zZSAxMDAgcm93cyBmcm9tICJwb3N0cyIgd2l0aCB0 aGUgbGFyZ2VzdCAiaWQiDQp0aGF0IGhhdmUgYSBtYXRjaCBpbiAiZm9sbG93 cyIgd2hlcmUgdGhlIGNvbmRpdGlvbiBpcyBmdWxmaWxsZWQuDQoNCkl0IGlz IGp1c3QgYSBkaWZmZXJlbnQgcGxhbiB0byBkbyB0aGUgc2FtZSB0aGluZyB0 aGF0IGlzIG1vcmUgZWZmaWNpZW50DQppbiB5b3VyIGNhc2UuDQoNCllvdXJz LA0KTGF1cmVueiBBbGJlDQoKLS0gClNlbnQgdmlhIHBnc3FsLXBlcmZvcm1h bmNlIG1haWxpbmcgbGlzdCAocGdzcWwtcGVyZm9ybWFuY2VAcG9zdGdyZXNx bC5vcmcpClRvIG1ha2UgY2hhbmdlcyB0byB5b3VyIHN1YnNjcmlwdGlvbjoK aHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tYWlscHJlZi9wZ3NxbC1wZXJm b3JtYW5jZQo=