Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dOOHd-0004bN-F2 for pgsql-performance@arkaria.postgresql.org; Fri, 23 Jun 2017 13:05:57 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dOOHc-00026T-S1 for pgsql-performance@arkaria.postgresql.org; Fri, 23 Jun 2017 13:05:56 +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 1dOOHb-00022i-Rm for pgsql-performance@postgresql.org; Fri, 23 Jun 2017 13:05:56 +0000 Received: from relay-ff112.magwien.gv.at ([217.149.228.140]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dOOHZ-0000mD-DN for pgsql-performance@postgresql.org; Fri, 23 Jun 2017 13:05:54 +0000 Received: from localhost (localhost [127.0.0.1]) by relay-ff112.magwien.gv.at (Postfix) with ESMTP id 2705620659; Fri, 23 Jun 2017 15:07:42 +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-ff112.magwien.gv.at (Postfix) with ESMTPS id 120D7205B8; Fri, 23 Jun 2017 15:07:41 +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 15:05:50 +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///lOYCAAAUFgIAANKUA Date: Fri, 23 Jun 2017 13:05:49 +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 b3Igc29ydGluZyAidGltZXN0YW1wIi4NCg0KWWVzLCBpZiB5b3UgcmVwbGFj ZSBwb3N0cy50aW1lc3RhbXAgd2l0aCBxLnRpbWVzdGFtcCwgaXQgc2hvdWxk DQpzb3J0IGJ5IHRoYXQuDQoNCkNvdWxkIHlvdSBzZW5kIENSRUFURSBUQUJM RSBhbmQgQ1JFQVRFIElOREVYIHN0YXRlbWVudHMgc28gSSBjYW4gdHJ5IGl0 Pw0KDQpZb3VycywNCkxhdXJlbnogQWxiZQ0KCi0tIApTZW50IHZpYSBwZ3Nx bC1wZXJmb3JtYW5jZSBtYWlsaW5nIGxpc3QgKHBnc3FsLXBlcmZvcm1hbmNl QHBvc3RncmVzcWwub3JnKQpUbyBtYWtlIGNoYW5nZXMgdG8geW91ciBzdWJz Y3JpcHRpb246Cmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHByZWYv cGdzcWwtcGVyZm9ybWFuY2UK