Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sgm4v-007few-81 for pgsql-committers@arkaria.postgresql.org; Wed, 21 Aug 2024 14:12:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sgm4s-00BcXz-U5 for pgsql-committers@arkaria.postgresql.org; Wed, 21 Aug 2024 14:12:47 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sgm4s-00BcXq-MA for pgsql-committers@lists.postgresql.org; Wed, 21 Aug 2024 14:12:47 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sgm4q-000k4q-KW for pgsql-committers@lists.postgresql.org; Wed, 21 Aug 2024 14:12:46 +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=7uHoKEi07ANsCUjXSUN/ccJXV6d/1wvBHLWNwrHpJJE=; b=UaiqR+XyT1PO9cirliErJEx2Ck KSmkl9CeZ5oX2167TPyRy0/CbD10askkOuJTJ1LdaWd69G9KVLuX3E5TaiKXjxOvT4bB7H3g3FRdW po84hq5agTWjFHjDrJdTpVm8r05oSJ1LiKVKeSaVEZoiVOCnaL0K3igb3cmqbBsHttdAEC6CjPkTc ly6yA/q1jmw2iEZqMOeGQE4kNry29mZ22NDf1gWHgIi5vUmfyX0EwdbkSpJCMfAUnmVhHssZXmbof byvJWAd/ohvggKNXV3OkHWqubs2CCqaUvgEDy+CuWGXtDmMOCzpc2I6Dkv0UqhNODbw9fqqUUSJ3/ I93ot9aQ==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sgm4p-002dBV-Lv for pgsql-committers@lists.postgresql.org; Wed, 21 Aug 2024 14:12:44 +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 1sgm4p-000mJW-Ii for pgsql-committers@lists.postgresql.org; Wed, 21 Aug 2024 14:12:43 +0000 Content-Type: multipart/mixed; boundary="===============8164486824663484936==" MIME-Version: 1.0 From: Robert Haas To: pgsql-committers@lists.postgresql.org Subject: pgsql: Treat number of disabled nodes in a path as a separate cost metr X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 21 Aug 2024 14:12:43 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8164486824663484936== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VHJlYXQgbnVtYmVyIG9mIGRpc2FibGVkIG5vZGVzIGluIGEgcGF0aCBhcyBhIHNlcGFyYXRlIGNv c3QgbWV0cmljLgoKUHJldmlvdXNseSwgd2hlbiBhIHBhdGggdHlwZSB3YXMgZGlzYWJsZWQgYnkg ZS5nLiBlbmFibGVfc2Vxc2Nhbj1mYWxzZSwKd2UgZWl0aGVyIGF2b2lkZWQgZ2VuZXJhdGluZyB0 aGF0IHBhdGggdHlwZSBpbiB0aGUgZmlyc3QgcGxhY2UsIG9yCm1vcmUgY29tbW9ubHksIHdlIGFk ZGVkIGEgbGFyZ2UgY29uc3RhbnQsIGNhbGxlZCBkaXNhYmxlX2Nvc3QsIHRvIHRoZQplc3RpbWF0 ZWQgc3RhcnR1cCBjb3N0IG9mIHRoYXQgcGF0aC4gVGhpcyBsYXR0ZXIgYXBwcm9hY2ggY2FuIGRp c3RvcnQKcGxhbm5pbmcuIEZvciBpbnN0YW5jZSwgYW4gZXh0cmVtZWx5IGV4cGVuc2l2ZSBub24t ZGlzYWJsZWQgcGF0aApjb3VsZCBzZWVtIHRvIGJlIHdvcnNlIHRoYW4gYSBkaXNhYmxlZCBwYXRo LCBlc3BlY2lhbGx5IGlmIHRoZSBmdWxsCmNvc3Qgb2YgdGhhdCBwYXRoIG5vZGUgbmVlZCBub3Qg YmUgcGFpZCAoZS5nLiBkdWUgdG8gYSBMaW1pdCkuCk9yLCBhcyBpbiB0aGUgcmVncmVzc2lvbiB0 ZXN0IHdob3NlIGV4cGVjdGVkIG91dHB1dCBjaGFuZ2VzIHdpdGggdGhpcwpjb21taXQsIHRoZSBh ZGRpdGlvbiBvZiBkaXNhYmxlX2Nvc3QgY2FuIG1ha2UgdHdvIHBhdGhzIHRoYXQgd291bGQKbm9y bWFsbHkgYmUgZGlzdGluZ3Vpc2hpYmxlIGluIGNvc3Qgc2VlbSB0byBoYXZlIGZ1enppbHkgdGhl IHNhbWUgY29zdC4KClRvIGZpeCB0aGF0LCB3ZSBub3cgY291bnQgdGhlIG51bWJlciBvZiBkaXNh YmxlZCBwYXRoIG5vZGVzIGFuZApjb25zaWRlciB0aGF0IGEgaGlnaC1vcmRlciBjb21wb25lbnQg b2YgYm90aCB0aGUgc3RhcnR1cCBjb3N0IGFuZCB0aGUKdG90YWwgY29zdC4gSGVuY2UsIHRoZSBw YXRoIGxpc3QgaXMgbm93IHNvcnRlZCBieSBkaXNhYmxlZF9ub2RlcyBhbmQKdGhlbiBieSB0b3Rh bF9jb3N0LCBpbnN0ZWFkIG9mIGp1c3QgYnkgdGhlIGxhdHRlciwgYW5kIGxpa2V3aXNlIGZvcgp0 aGUgcGFydGlhbCBwYXRoIGxpc3QuICBJdCBpcyBpbXBvcnRhbnQgdGhhdCB0aGlzIG51bWJlciBp cyBhIGNvdW50CmFuZCBub3Qgc2ltcGx5IGEgQm9vbGVhbjsgZWxzZSwgYXMgc29vbiBhcyB3ZSdy ZSB1bmFibGUgdG8gcmVzcGVjdApkaXNhYmxlZCBwYXRoIHR5cGVzIGluIGFsbCBwb3J0aW9ucyBv ZiB0aGUgcGF0aCwgd2Ugc3RvcCB0cnlpbmcgdG8KYXZvaWQgdGhlbSB3aGVyZSB3ZSBjYW4uCgpC ZWNhdXNlIHRoZSBwYXRoIGxpc3QgaXMgbm93IHNvcnRlZCBieSB0aGUgbnVtYmVyIG9mIGRpc2Fi bGVkIG5vZGVzLAp0aGUgam9pbiBwcmVjaGVja3MgbXVzdCBjb21wdXRlIHRoZSBjb3VudCBvZiBk aXNhYmxlZCBub2RlcyBkdXJpbmcKdGhlIGluaXRpYWwgY29zdCBwaGFzZSBpbnN0ZWFkIG9mIHBv c3Rwb25pbmcgaXQgdG8gZmluYWwgY29zdCB0aW1lLgoKQ291bnRzIG9mIGRpc2FibGVkIG5vZGVz IGRvIG5vdCBjcm9zcyBzdWJxdWVyeSBsZXZlbHM7IGF0IHByZXNlbnQsCnRoZXJlIGlzIG5vIHJl YXNvbiBmb3IgdGhlbSB0byBkbyBzbywgc2luY2UgdGhlIHdlIGRvIG5vdCBwb3N0cG9uZQpwYXRo IHNlbGVjdGlvbiBhY3Jvc3Mgc3VicXVlcnkgYm91bmRhcmllcyAoc2VlIG1ha2Vfc3VicGxhbiku CgpSZXZpZXdlZCBieSBBbmRyZXMgRnJldW5kLCBIZWlra2kgTGlubmFrYW5nYXMsIGFuZCBEYXZp ZCBSb3dsZXkuCgpEaXNjdXNzaW9uOiBodHRwOi8vcG9zdGdyLmVzL20vQ0ErVGdtb1pfK01TK282 TmVHSzJ4eUJ2LXhNK3cxQWZGVnVIRTRmX2FxNmVrSHY3WVNRQG1haWwuZ21haWwuY29tCgpCcmFu Y2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwu b3JnL3BnL2NvbW1pdGRpZmYvZTIyMjUzNDY3OTQyZmRiMTAwMDg3Nzg3YzNlMWUzYTg2MjBjNTRi MgoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KY29udHJpYi9maWxlX2Zkdy9maWxlX2Zk dy5jICAgICAgICAgICAgICAgICAgIHwgICAxICsKY29udHJpYi9wb3N0Z3Jlc19mZHcvcG9zdGdy ZXNfZmR3LmMgICAgICAgICAgIHwgIDQ2ICsrKysrLQpjb250cmliL3Bvc3RncmVzX2Zkdy9wb3N0 Z3Jlc19mZHcuaCAgICAgICAgICAgfCAgIDEgKwpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9j b3N0c2l6ZS5jICAgICAgICAgfCAxNTUgKysrKysrKysrKysrKy0tLS0tLQpzcmMvYmFja2VuZC9v cHRpbWl6ZXIvcGF0aC9qb2lucGF0aC5jICAgICAgICAgfCAgMTUgKy0Kc3JjL2JhY2tlbmQvb3B0 aW1pemVyL3BsYW4vY3JlYXRlcGxhbi5jICAgICAgIHwgICAyICsKc3JjL2JhY2tlbmQvb3B0aW1p emVyL3BsYW4vcGxhbm5lci5jICAgICAgICAgIHwgICAxICsKc3JjL2JhY2tlbmQvb3B0aW1pemVy L3ByZXAvcHJlcHVuaW9uLmMgICAgICAgIHwgICA2ICstCnNyYy9iYWNrZW5kL29wdGltaXplci91 dGlsL3BhdGhub2RlLmMgICAgICAgICB8IDIxMiArKysrKysrKysrKysrKysrKysrLS0tLS0tLQpz cmMvaW5jbHVkZS9ub2Rlcy9wYXRobm9kZXMuaCAgICAgICAgICAgICAgICAgfCAgIDIgKwpzcmMv aW5jbHVkZS9vcHRpbWl6ZXIvY29zdC5oICAgICAgICAgICAgICAgICAgfCAgMTAgKy0Kc3JjL2lu Y2x1ZGUvb3B0aW1pemVyL3BhdGhub2RlLmggICAgICAgICAgICAgIHwgIDEyICstCnNyYy90ZXN0 L2lzb2xhdGlvbi9zcGVjcy9ob3Jpem9ucy5zcGVjICAgICAgICB8ICAgMSAtCnNyYy90ZXN0L3Jl Z3Jlc3MvZXhwZWN0ZWQvYnRyZWVfaW5kZXgub3V0ICAgICB8ICAxMiArLQpzcmMvdGVzdC9yZWdy ZXNzL2V4cGVjdGVkL3NlbGVjdF9wYXJhbGxlbC5vdXQgfCAgIDggKy0KMTUgZmlsZXMgY2hhbmdl ZCwgMzU3IGluc2VydGlvbnMoKyksIDEyNyBkZWxldGlvbnMoLSkKCg== --===============8164486824663484936==--