Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p60Ng-0000zr-W4 for pgsql-committers@arkaria.postgresql.org; Fri, 16 Dec 2022 02:23:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p60Ne-0000sm-L3 for pgsql-committers@arkaria.postgresql.org; Fri, 16 Dec 2022 02:23:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p60Ne-0000sd-0w for pgsql-committers@lists.postgresql.org; Fri, 16 Dec 2022 02:23:22 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p60Nb-000422-2n for pgsql-committers@lists.postgresql.org; Fri, 16 Dec 2022 02:23:21 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=iysc5MA+ekzIph4zS/TjN0BlLRyItKvt5T/+cWIfxws=; b=wucxD5Zx7BI20y3UsKrGjfF5wz nfWvhJO5vM8PZYnJQw+Y0P50Byq8sqH3dDT6VnFdL0zmogZsn4gKxGQeRpStXYuRJ3LspAh15F+KD q+yjhlqTQRRlzvwW9DOOD/kVmDepbhZBF+GKpX9X0RbgGqNJfKjOJ3281FrE/uDv/iKbwer16WXWG sjsxqm4rgI7qM/AlClMJ3XAUkR99qJTQacBJ7jW3o9jm0rCBSShnhLoZmp0vgdhzquum/EoPsOgq2 tQJH3OSORaN/Jek+RYeUjOmp6FYjcRTfAf2zrVoVbyPDa5YRVFodGERmv7JZqRQRTQx+uUP0QtYis uQ6p4PgA==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p60NZ-0008Lf-Lq for pgsql-committers@lists.postgresql.org; Fri, 16 Dec 2022 02:23:17 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1p60NX-003oPg-P0 for pgsql-committers@lists.postgresql.org; Fri, 16 Dec 2022 02:23:16 +0000 Content-Type: multipart/mixed; boundary="===============4634700547927112733==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Remove pessimistic cost penalization from Incremental Sort X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 16 Dec 2022 02:23:16 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4634700547927112733== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmVtb3ZlIHBlc3NpbWlzdGljIGNvc3QgcGVuYWxpemF0aW9uIGZyb20gSW5jcmVtZW50YWwgU29y dAoKV2hlbiBpbmNyZW1lbnRhbCBzb3J0cyB3ZXJlIGFkZGVkIGluIHYxMyBhIDEuNXggcGVzc2lt aXNtIGZhY3RvciB3YXMgYWRkZWQKdG8gdGhlIGNvc3QgbW9kYWwuICBTZWVtaW5nbHkgdGhpcyB3 YXMgZG9uZSBiZWNhdXNlIHRoZSBjb3N0IG1vZGFsIG9ubHkKaGFzIGFuIGVzdGltYXRlIG9mIHRo ZSB0b3RhbCBudW1iZXIgb2YgaW5wdXQgcm93cyBhbmQgdGhlIG51bWJlciBvZgpwcmVzb3J0ZWQg Z3JvdXBzLiAgSXQgYXNzdW1lcyB0aGF0IHRoZSBpbnB1dCByb3dzIHdpbGwgYmUgZXZlbmx5CmRp c3RyaWJ1dGVkIHRocm91Z2hvdXQgdGhlIHByZXNvcnRlZCBncm91cHMuICBUaGUgMS41eCBwZXNz aW1pc20gZmFjdG9yCndhcyBhZGRlZCB0byBzbGlnaHRseSByZWR1Y2UgdGhlIGxpa2VsaWhvb2Qg b2YgaW5jcmVtZW50YWwgc29ydHMgYmVpbmcKdXNlZCBpbiB0aGUgaG9wZSB0byBhdm9pZCBwZXJm b3JtYW5jZSByZWdyZXNzaW9ucyB3aGVyZSBhbiBpbmNyZW1lbnRhbApzb3J0IHBsYW4gd2FzIHBp Y2tlZCBhbmQgdHVybmVkIG91dCBzbG93ZXIgZHVlIHRvIGEgbGFyZ2Ugc2tldyBpbiB0aGUKbnVt YmVyIG9mIHJvd3MgaW4gdGhlIHByZXNvcnRlZCBncm91cHMuCgpBbiBhZGRpdGlvbmFsIHF1aXJr IHdpdGggdGhlIHBhdGggZ2VuZXJhdGlvbiBjb2RlIG1lYW50IHRoYXQgd2UgY291bGQKY29uc2lk ZXIgYm90aCBhIHNvcnQgYW5kIGFuIGluY3JlbWVudGFsIHNvcnQgb24gcGF0aHMgd2l0aCBwcmVz b3J0ZWQga2V5cy4KVGhpcyBtZWFudCB0aGF0IHdpdGggdGhlIHBlc3NpbWlzbSBmYWN0b3IsIGl0 IHdhcyBwb3NzaWJsZSB0aGF0IHdlIG9wdGVkCnRvIHBlcmZvcm0gYSBzb3J0IHJhdGhlciB0aGFu IGFuIGluY3JlbWVudGFsIHNvcnQgd2hlbiB0aGUgZ2l2ZW4gcGF0aCBoYWQKcHJlc29ydGVkIGtl eXMuCgpIZXJlIHdlIHJlbW92ZSB0aGUgMS41eCBwZXNzaW1pc20gZmFjdG9yIHRvIGFsbG93IGlu Y3JlbWVudGFsIHNvcnRzIHRvCmhhdmUgYSBmYWlyZXIgY2hhbmNlIGF0IGJlaW5nIGNob3NlbiBh Z2FpbnN0IGEgZnVsbCBzb3J0LgoKUHJldmlvdXNseSB3ZSB3b3VsZCBnZW5lcmFsbHkgY3JlYXRl IGEgc29ydCBwYXRoIG9uIHRoZSBjaGVhcGVzdCBpbnB1dApwYXRoIChpZiB0aGF0IHdhc24ndCBz b3J0ZWQgYWxyZWFkeSkgYW5kIGluY3JlbWVudGFsIHNvcnQgcGF0aHMgb24gYW55CnBhdGggd2hp Y2ggaGFkIHByZXNvcnRlZCBrZXlzLiAgVGhpcyBtZWFudCB0aGF0IGlmIHRoZSBjaGVhcGVzdCBp bnB1dCBwYXRoCndhc24ndCBjb21wbGV0ZWx5IHNvcnRlZCBidXQgaGFwcGVuZWQgdG8gaGF2ZSBw cmVzb3J0ZWQga2V5cywgd2Ugd291bGQKY3JlYXRlIGEgZnVsbCBzb3J0IHBhdGggKmFuZCogYW4g aW5jcmVtZW50YWwgc29ydCBwYXRoIG9uIHRoYXQgaW5wdXQgcGF0aC4KSGVyZSB3ZSBjaGFuZ2Ug dGhpcyBsb2dpYyBzbyB0aGF0IGlmIHRoZXJlIGFyZSBwcmVzb3J0ZWQga2V5cywgd2Ugb25seQpj cmVhdGUgYW4gaW5jcmVtZW50YWwgc29ydCBwYXRoLCBhbmQgY3JlYXRlIHNvcnQgcGF0aHMgb25s eSB3aGVuIGEgZnVsbApzb3J0IGlzIHJlcXVpcmVkLgoKQm90aCB0aGUgcmVtb3ZhbCBvZiB0aGUg Y29zdCBwZXNzaW1pc20gZmFjdG9yIGFuZCB0aGUgY2hhbmdlcyBtYWRlIHRvIHRoZQpwYXRoIGdl bmVyYXRpb24gbWFrZSBpdCBtb3JlIGxpa2VseSB0aGF0IGluY3JlbWVudGFsIHNvcnRzIHdpbGwg bm93IGJlCmNob3Nlbi4gIFRoYXQsIG9mIGNvdXJzZSwgYXMgd2l0aCB0ZWFjaGluZyB0aGUgcGxh bm5lciBhbnkgbmV3IHRyaWNrcywKbWVhbnMgYW4gaW5jcmVhc2VkIGxpa2VsaWhvb2QgdGhhdCB0 aGUgcGxhbm5lciB3aWxsIHBlcmZvcm0gYW4gaW5jcmVtZW50YWwKc29ydCB3aGVuIGl0J3Mgbm90 IHRoZSBiZXN0IG1ldGhvZC4gIE91ciBzdGFuZGFyZCBlc2NhcGUgaGF0Y2ggZm9yIHRoZXNlCmNh c2VzIGlzIGFuIGVuYWJsZV8qIEdVQy4gIGVuYWJsZV9pbmNyZW1lbnRhbF9zb3J0IGFscmVhZHkg ZXhpc3RzIGZvcgp0aGlzLgoKVGhpcyBjYW1lIG91dCBvZiBhIHJlcG9ydCBieSBQYXZlbCBMdXph bm92IHdoZXJlIGhlIG1lbnRpb25lZCB0aGF0IHRoZQptYXN0ZXIgYnJhbmNoIHdhcyBjaG9vc2lu ZyB0byBwZXJmb3JtIGEgU2VxIFNjYW4gLT4gU29ydCAtPiBHcm91cApBZ2dyZWdhdGUgZm9yIGhp cyBxdWVyeSB3aXRoIGFuIE9SREVSIEJZIGFnZ3JlZ2F0ZSBmdW5jdGlvbi4gIFRoZSB2MTUgcGxh bgpmb3IgaGlzIHF1ZXJ5IHBlcmZvcm1lZCBhbiBJbmRleCBTY2FuIC0+IEdyb3VwIEFnZ3JlZ2F0 ZSwgb2YgY291cnNlLCB0aGUKYWdncmVnYXRlIHBlcmZvcm1lZCB0aGUgZmluYWwgc29ydCBpbnRl cm5hbGx5IGluIG5vZGVBZ2cuYyBmb3IgdGhlCmFnZ3JlZ2F0ZSdzIE9SREVSIEJZLiAgVGhlIGlk ZWFsIHBsYW4gd291bGQgaGF2ZSBiZWVuIHRvIHVzZSB0aGUgaW5kZXgsCndoaWNoIHByb3ZpZGVk IHBhcnRpYWxseSBzb3J0ZWQgaW5wdXQgdGhlbiB1c2UgYW4gaW5jcmVtZW50YWwgc29ydCB0bwpw cm92aWRlIHRoZSBhZ2dyZWdhdGUgd2l0aCB0aGUgc29ydGVkIGlucHV0LiAgVGhpcyB3YXMgbm90 IGJlaW5nIGNob3NlbgpkdWUgdG8gdGhlIHBlc3NpbWlzbSBpbiB0aGUgaW5jcmVtZW50YWwgc29y dCBjb3N0IG1vZGFsLCBzbyBoZXJlIHdlIHJlbW92ZQp0aGF0IGFuZCByYXRpb25hbGl6ZSB0aGUg cGF0aCBnZW5lcmF0aW9uIHNvIHRoYXQgc29ydCBhbmQgaW5jcmVtZW50YWwgc29ydApwbGFucyBk b24ndCBoYXZlIHRvIG5lZWRsZXNzbHkgY29tcGV0ZS4gIFdlIGFzc3VtZSB0aGF0IGl0J3Mgc2Vu c2VsZXNzCnRvIGV2ZXIgdXNlIGEgZnVsbCBzb3J0IG9uIGEgZ2l2ZW4gaW5wdXQgcGF0aCB3aGVy ZSBhbiBpbmNyZW1lbnRhbCBzb3J0CmNhbiBiZSBwZXJmb3JtZWQuCgpSZXBvcnRlZC1ieTogUGF2 ZWwgTHV6YW5vdgpSZXZpZXdlZC1ieTogUmljaGFyZCBHdW8KRGlzY3Vzc2lvbjogaHR0cHM6Ly9w b3N0Z3IuZXMvbS85ZjYxZGRiZi0yOTg5LTE1MzYtYjMxZS02NDU5MzcwYTZiYWElNDBwb3N0Z3Jl c3Byby5ydQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dp dC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzRhMjllYWJkMWQ5MWM1NDg0NDI2YmM1ODM2 ZTBhNzE0M2IwNjRmNWEKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmNvbnRyaWIvcG9z dGdyZXNfZmR3L2V4cGVjdGVkL3Bvc3RncmVzX2Zkdy5vdXQgfCAgIDIgKwpjb250cmliL3Bvc3Rn cmVzX2Zkdy9zcWwvcG9zdGdyZXNfZmR3LnNxbCAgICAgIHwgICAyICsKc3JjL2JhY2tlbmQvb3B0 aW1pemVyL3BhdGgvYWxscGF0aHMuYyAgICAgICAgICB8ICA5NCArKy0tLQpzcmMvYmFja2VuZC9v cHRpbWl6ZXIvcGF0aC9jb3N0c2l6ZS5jICAgICAgICAgIHwgIDM4ICstCnNyYy9iYWNrZW5kL29w dGltaXplci9wbGFuL3BsYW5uZXIuYyAgICAgICAgICAgfCA0ODAgKysrKysrKystLS0tLS0tLS0t LS0tLS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2luY3JlbWVudGFsX3NvcnQub3V0IHwg IDEzIC0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9wYXJ0aXRpb25fam9pbi5vdXQgICB8ICAg NSArLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC9pbmNyZW1lbnRhbF9zb3J0LnNxbCAgICAgIHwgICA1 IC0KOCBmaWxlcyBjaGFuZ2VkLCAyMjAgaW5zZXJ0aW9ucygrKSwgNDE5IGRlbGV0aW9ucygtKQoK --===============4634700547927112733==--