Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eEP3X-00056t-H9 for pgsql-performance@arkaria.postgresql.org; Tue, 14 Nov 2017 00:26:23 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1eEP3X-0002vP-4h for pgsql-performance@arkaria.postgresql.org; Tue, 14 Nov 2017 00:26: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 1eEL0H-0005Rq-76 for pgsql-performance@postgresql.org; Mon, 13 Nov 2017 20:06:45 +0000 Received: from mail.index.de ([213.160.90.22]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eEL0D-0006yR-RF for pgsql-performance@postgresql.org; Mon, 13 Nov 2017 20:06:44 +0000 Received: from localhost (mail1.index.de [127.0.0.1]) by mail.index.de (Postfix) with ESMTP id A76074420BE; Mon, 13 Nov 2017 21:06:38 +0100 (CET) Received: from mail.index.de ([127.0.0.1]) by localhost (mail.index.de [127.0.0.1]) (amavisd-new, port 10024) with LMTP id pgZYetPgy3dD; Mon, 13 Nov 2017 21:06:38 +0100 (CET) Received: from remote.index.de (unknown [217.199.72.165]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by mail.index.de (Postfix) with ESMTPSA id 77B82441FC4; Mon, 13 Nov 2017 21:06:38 +0100 (CET) Received: from acedia.index-gruppe.local (192.168.3.121) by acedia.index-gruppe.local (192.168.3.121) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256) id 15.1.1034.26; Mon, 13 Nov 2017 21:06:20 +0100 Received: from acedia.index-gruppe.local ([fe80::ecd1:5d0a:a834:dd56]) by acedia.index-gruppe.local ([fe80::ecd1:5d0a:a834:dd56%2]) with mapi id 15.01.1034.032; Mon, 13 Nov 2017 21:06:20 +0100 From: Arne Roland To: Oliver Mattos , "pgsql-performance@postgresql.org" Subject: Re: Query planner gaining the ability to replanning after start of query execution. Thread-Topic: [PERFORM] Query planner gaining the ability to replanning after start of query execution. Thread-Index: AQHTXJ9tLJwS5jJPj0S8PshkQTAXbaMSpXJA Date: Mon, 13 Nov 2017 20:06:20 +0000 Message-ID: <252cab3895894337a3a88275f423fe0b@index.de> References: In-Reply-To: Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [192.168.3.146] 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 SGVsbG8sDQoNCkknZCBsb3ZlIHRvIGhhdmUgc29tZSBzb3J0IG9mIGR5bmFt aWMgcXVlcnkgZmVlZGJhY2ssIHlldCBpdCdzIHZlcnkgY29tcGxpY2F0ZWQg dG8gZG8gaXQgcmlnaHQuIEkgYW0gbm90IGNvbnZpbmNlZCB0aGF0IGNoYW5n aW5nIHRoZSBwbGFuIGR1cmluZyBhIHNpbmdsZSBleGVjdXRpb24gaXMgdGhl IHJpZ2h0IHdheSB0byBkbyBpdCwgbm90IG9ubHkgYmVjYXVzZSBpdCBzb3Vu ZHMgaW50cnVzaXZlIHRvIGRvIGNyYXp5IHRoaW5ncyBpbiB0aGUgZXhlY3V0 b3IsIGJ1dCBhbHNvIGJlY2F1c2UgZG9uJ3QgdW5kZXJzdGFuZCB3aHkgdGhl IG5ldyBwbGFuIHNob3VsZCBiZSBhbnkgYmV0dGVyIHRoYW4gdGhlIG9sZCBv bmUuIENhbiB5b3UgYmUgbW9yZSBlbGFib3JhdGUgaG93IHlvdSdkIHdhbnQg dG8gZ28gYWJvdXQgaXQ/DQoNCkluIHlvdXIgZXhhbXBsZSAod2hpY2ggcHJl c3VtYWJseSBqdXN0IGhhcyBhIHNpbmdsZSByZWxhdGlvbiksIHdlIGhhdmUg bm8gbm90aW9uIG9mIHdoZXRoZXIgdGhlIHNjYW4gcmV0dXJucyBubyByb3dz IGJlY2F1c2Ugd2Ugd2VyZSB1bmx1Y2t5LCBiZWNhdXNlIGp1c3QgdGhlIGZp cnN0IGZldyBwYWdlcyB3ZXJlIGVtcHR5IG9mIG1hdGNoaW5nIHJvd3MgKHdo aWNoIGluIG15IGV4cGVyaWVuY2UgaGFwcGVucyBtb3JlIG9mdGVuKSwgb3Ig YmVjYXVzZSB0aGUgY2FyZGluYWxpdHkgZXN0aW1hdGlvbiBpcyB3cm9uZy4g RXZlbiBpZiB0aGUgY2FyZGluYWxpdHkgZXN0aW1hdGlvbiBpcyB3cm9uZywg d2UgaGF2ZSBubyBub3Rpb24gb2Ygd2hpY2ggcHJlZGljYXRlIG9yIHByZWRp Y2F0ZSBjb21iaW5hdGlvbiBhY3R1YWxseSBjYXVzZWQgdGhlIG1pc2VzdGlt YXRpb24uIElmIHRoZSBmaXJzdCBmZXcgcGFnZXMgd2hlcmUgZW1wdHksIHRo ZSBzYW1lIG1pZ2h0IGhhcHBlbiB3aXRoIGV2ZXJ5IG9yZGVyIChzbyBhbHNv IHdpdGggZXZlcnkgYXZhaWxhYmxlIGluZGV4c2NhbikuIEltYWdpbmUgYSB2 ZXJ5IHNpbXBsZSBzZXFzY2FuIHBsYW4gb2YgDQpzZWxlY3QgKiBmcm9tIG15 dGFiIHdoZXJlIGEgPSAzIGFuZCBiID0gNDAgbGltaXQgMQ0KRXZlbiBpZiB3 ZSBrbm93IHRoZSBjYXJkaW5hbGl0eSBpcyBvdmVyZXN0aW1hdGVkLCB3ZSBo YXZlIG5vIGlkZWEgd2hldGhlciB0aGUgY2FyZGluYWxpdHkgb2YgYSA9IDMg b3IgYiA9IDQwIGlzIHdyb25nIG9yIHRoZXkganVzdCBjb3JyZWxhdGUsIHNv IHRoZXJlIGlzIG5vIG5vdGlvbiBvZiB3aGljaCBpcyBhY3R1YWxseSB0aGUg Y2hlYXBlc3QgcGxhbi4gVXN1YWwgd29ya2Fyb3VuZCBmb3IgbW9zdCBvZiB0 aGVzZSBxdWVyaWVzIGlzIHRvIGFkZCBhbiBvcmRlciBieSAod2hpY2ggaGFz IHRoZSBuaWNlIGFkZGl0aW9uIG9mIGhhdmluZyBhIGRldGVybWluaXN0aWMg cmVzdWx0KSB3aXRoIGFuIGFwcHJvcHJpYXRlIGNvbXBsZXggaW5kZXgsIHVz dWFsbHkgcmVzdWx0aW5nIGluIGluZGV4c2NhbnMuDQoNCldoaWxlIHdlIGFj dHVhbGx5IGtub3cgbW9yZSBhZnRlciB0aGUgZmlyc3QgZXhlY3V0aW9uIG9m IGEgbm9kZXMgbGlrZSBtYXRlcmlhbGl6ZSwgc29ydCBvciBoYXNoIG5vZGVz LCBJIHJhcmVseSBlbmNvdW50ZXIgbWF0ZXJpYWxpemUgbm9kZXMgaW4gdGhl IHdpbGQuIENvbnNlcXVlbnRseSB0aGF0IGlzIHRoZSBwbGFjZSB3aGVyZSB0 aGUgd29yayBpcyB1c3VhbGx5IGFscmVhZHkgZG9uZSwgd2hpY2ggaXMgZXNw ZWNpYWxseSB0cnVlIHdpdGggdGhlIGhhc2ggbm9kZS4gRXZlbiB0aG91Z2gg aXQgc3RpbGwgbWlnaHQgYmUgbW9yZSBvcHRpbWFsIHRvIHN3aXRjaCBmcm9t IGEgbWVyZ2Vqb2luIHRvIGEgaGFzaGpvaW4gaW4gc29tZSBjYXNlcywgSSBk b3VidCB0aGF0J3Mgd29ydGggYW55IHdvcmsgKGFuZCBldmVuIGxlc3MgdGhl IG1haW50ZW5hbmNlKS4NCg0KQmVzdCByZWdhcmRzDQpBcm5lIFJvbGFuZA0K DQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogcGdzcWwtcGVy Zm9ybWFuY2Utb3duZXJAcG9zdGdyZXNxbC5vcmcgW21haWx0bzpwZ3NxbC1w ZXJmb3JtYW5jZS1vd25lckBwb3N0Z3Jlc3FsLm9yZ10gT24gQmVoYWxmIE9m IE9saXZlciBNYXR0b3MNClNlbnQ6IE1vbmRheSwgTm92ZW1iZXIgMTMsIDIw MTcgNTo0NSBQTQ0KVG86IHBnc3FsLXBlcmZvcm1hbmNlQHBvc3RncmVzcWwu b3JnDQpTdWJqZWN0OiBbUEVSRk9STV0gUXVlcnkgcGxhbm5lciBnYWluaW5n IHRoZSBhYmlsaXR5IHRvIHJlcGxhbm5pbmcgYWZ0ZXIgc3RhcnQgb2YgcXVl cnkgZXhlY3V0aW9uLg0KDQpJIGFtIGludGVyZXN0ZWQgaW4gZ2l2aW5nIHRo ZSBxdWVyeSBwbGFubmVyIHRoZSBhYmlsaXR5IHRvIHJlcGxhbiAob3IgcmUt cmFuayBwbGFucykgYWZ0ZXIgcXVlcnkgZXhlY3V0aW9uIGhhcyBiZWd1biwg YmFzZWQgb24gdGhlIHByb2dyZXNzaW9uIG9mIHRoZSBxdWVyeSBzbyBmYXIu DQoNCkV4YW1wbGUgdXNlIGNhc2U6DQoNCiogIEEgTElNSVQgMSBxdWVyeSBp cyBwbGFubmVkIHVzaW5nIGFuIGV4cGVuc2l2ZSBzY2FuIHdoaWNoIHRoZSBw bGFubmVyIGV4cGVjdHMgdG8gcmV0dXJuIGEgbGFyZ2UgbnVtYmVyIG9mIHJl c3VsdHMsIGFuZCB0byB0ZXJtaW5hdGUNCmVhcmx5LiAgIFRoZSByZWFsaXR5 IGlzIHRoZSBxdWVyeSBhY3R1YWxseSBwcm9kdWNlcyBubyByZXN1bHRzLCBh bmQNCnRoZSBzY2FuIG11c3QgcnVuIHRvIGNvbXBsZXRpb24sIHBvdGVudGlh bGx5IHRha2luZyB0aG91c2FuZHMgb2YgdGltZXMgbG9uZ2VyIHRoYW4gZXhw ZWN0ZWQuDQoNCiogIElmIHRoaXMgcGxhbnMgY29zdHMgd2VyZSBhZGp1c3Rl ZCBtaWQtZXhlY3V0aW9uIHRvIHJlZmxlY3QgdGhlIGZhY3QgdGhhdCB0aGUg c2NhbiBpcyBwcm9kdWNpbmcgZmFyIGZld2VyIHJvd3MgdGhhbiBleHBlY3Rl ZCwgdGhlbiBhbm90aGVyIHF1ZXJ5IHBsYW4gbWlnaHQgY29tZSBvdXQgYWhl YWQsIHdoaWNoIHdvdWxkIGNvbXBsZXRlIGZhciBmYXN0ZXIuDQoNCg0KSGFz IHRoaXMgYmVlbiBkb25lIGJlZm9yZT8gICBBcmUgdGhlcmUgYW55IHBpdGZh bGxzIHRvIGJld2FyZSBvZj8NCg0KDQotLQ0KU2VudCB2aWEgcGdzcWwtcGVy Zm9ybWFuY2UgbWFpbGluZyBsaXN0IChwZ3NxbC1wZXJmb3JtYW5jZUBwb3N0 Z3Jlc3FsLm9yZykNClRvIG1ha2UgY2hhbmdlcyB0byB5b3VyIHN1YnNjcmlw dGlvbjoNCmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHByZWYvcGdz cWwtcGVyZm9ybWFuY2UNCg0KDQoNCg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdl LS0tLS0NCkZyb206IHBnc3FsLXBlcmZvcm1hbmNlLW93bmVyQHBvc3RncmVz cWwub3JnIFttYWlsdG86cGdzcWwtcGVyZm9ybWFuY2Utb3duZXJAcG9zdGdy ZXNxbC5vcmddIE9uIEJlaGFsZiBPZiBPbGl2ZXIgTWF0dG9zDQpTZW50OiBN b25kYXksIE5vdmVtYmVyIDEzLCAyMDE3IDU6NDUgUE0NClRvOiBwZ3NxbC1w ZXJmb3JtYW5jZUBwb3N0Z3Jlc3FsLm9yZw0KU3ViamVjdDogW1BFUkZPUk1d IFF1ZXJ5IHBsYW5uZXIgZ2FpbmluZyB0aGUgYWJpbGl0eSB0byByZXBsYW5u aW5nIGFmdGVyIHN0YXJ0IG9mIHF1ZXJ5IGV4ZWN1dGlvbi4NCg0KSSBhbSBp bnRlcmVzdGVkIGluIGdpdmluZyB0aGUgcXVlcnkgcGxhbm5lciB0aGUgYWJp bGl0eSB0byByZXBsYW4gKG9yIHJlLXJhbmsgcGxhbnMpIGFmdGVyIHF1ZXJ5 IGV4ZWN1dGlvbiBoYXMgYmVndW4sIGJhc2VkIG9uIHRoZSBwcm9ncmVzc2lv biBvZiB0aGUgcXVlcnkgc28gZmFyLg0KDQpFeGFtcGxlIHVzZSBjYXNlOg0K DQoqICBBIExJTUlUIDEgcXVlcnkgaXMgcGxhbm5lZCB1c2luZyBhbiBleHBl bnNpdmUgc2NhbiB3aGljaCB0aGUgcGxhbm5lciBleHBlY3RzIHRvIHJldHVy biBhIGxhcmdlIG51bWJlciBvZiByZXN1bHRzLCBhbmQgdG8gdGVybWluYXRl DQplYXJseS4gICBUaGUgcmVhbGl0eSBpcyB0aGUgcXVlcnkgYWN0dWFsbHkg cHJvZHVjZXMgbm8gcmVzdWx0cywgYW5kDQp0aGUgc2NhbiBtdXN0IHJ1biB0 byBjb21wbGV0aW9uLCBwb3RlbnRpYWxseSB0YWtpbmcgdGhvdXNhbmRzIG9m IHRpbWVzIGxvbmdlciB0aGFuIGV4cGVjdGVkLg0KDQoqICBJZiB0aGlzIHBs YW5zIGNvc3RzIHdlcmUgYWRqdXN0ZWQgbWlkLWV4ZWN1dGlvbiB0byByZWZs ZWN0IHRoZSBmYWN0IHRoYXQgdGhlIHNjYW4gaXMgcHJvZHVjaW5nIGZhciBm ZXdlciByb3dzIHRoYW4gZXhwZWN0ZWQsIHRoZW4gYW5vdGhlciBxdWVyeSBw bGFuIG1pZ2h0IGNvbWUgb3V0IGFoZWFkLCB3aGljaCB3b3VsZCBjb21wbGV0 ZSBmYXIgZmFzdGVyLg0KDQoNCkhhcyB0aGlzIGJlZW4gZG9uZSBiZWZvcmU/ ICAgQXJlIHRoZXJlIGFueSBwaXRmYWxscyB0byBiZXdhcmUgb2Y/DQoNCg0K LS0NClNlbnQgdmlhIHBnc3FsLXBlcmZvcm1hbmNlIG1haWxpbmcgbGlzdCAo cGdzcWwtcGVyZm9ybWFuY2VAcG9zdGdyZXNxbC5vcmcpDQpUbyBtYWtlIGNo YW5nZXMgdG8geW91ciBzdWJzY3JpcHRpb246DQpodHRwOi8vd3d3LnBvc3Rn cmVzcWwub3JnL21haWxwcmVmL3Bnc3FsLXBlcmZvcm1hbmNlDQoNCg0KDQoK LS0gClNlbnQgdmlhIHBnc3FsLXBlcmZvcm1hbmNlIG1haWxpbmcgbGlzdCAo cGdzcWwtcGVyZm9ybWFuY2VAcG9zdGdyZXNxbC5vcmcpClRvIG1ha2UgY2hh bmdlcyB0byB5b3VyIHN1YnNjcmlwdGlvbjoKaHR0cDovL3d3dy5wb3N0Z3Jl c3FsLm9yZy9tYWlscHJlZi9wZ3NxbC1wZXJmb3JtYW5jZQo=