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 1opr5N-0000zt-9Q for pgsql-bugs@arkaria.postgresql.org; Tue, 01 Nov 2022 13:13:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1opr5M-0002NN-5F for pgsql-bugs@arkaria.postgresql.org; Tue, 01 Nov 2022 13:13:44 +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 1opr5L-0002NE-RU for pgsql-bugs@lists.postgresql.org; Tue, 01 Nov 2022 13:13:43 +0000 Received: from www.pro-open.de ([46.4.51.10]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1opr5J-0004LW-QO for pgsql-bugs@lists.postgresql.org; Tue, 01 Nov 2022 13:13:43 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by www.pro-open.de (Postfix) with ESMTP id 3E91945A8390; Tue, 1 Nov 2022 14:13:40 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at pro-open.de Received: from www.pro-open.de ([127.0.0.1]) by localhost (www.pro-open.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id qDaBrQaEMJNF; Tue, 1 Nov 2022 14:13:39 +0100 (CET) Received: from [192.168.0.42] (p5defcd3c.dip0.t-ipconnect.de [93.239.205.60]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) by www.pro-open.de (Postfix) with ESMTPSA id 96EFE45A838E; Tue, 1 Nov 2022 14:13:39 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=pro-open.de; s=dkim; t=1667308419; bh=X8vZKLAyLhf0H++ylpZC8JBqvVtoe+BMMpMwCNe6Ops=; h=Date:Subject:To:Cc:References:From:In-Reply-To:From; b=abqcTVB3dVyHEEmOG1DQuv/0HHs0Xd+gCOVhtM5+2LnI8gkpBrvNumt71Xtr/Ar/l 5a2OaM/4lASUGHUX1BWWyRo812Z21NrQIUh8EMSVQGRnIZ3TeU4IsYF4/+FLXGgdf6 wG8XdGTBI05+1FH+nu+pbEsvctMbaymmht1KTyoBRLcLwyqBhLd18pfEfHUIW1CIl1 R95y7+SYhb7AVqMUnueODkB/Gt6c+CpofrvB7tHUa9MEy6S4qao4uD7sfnelzNTsHb 9Az5LEdEL4shFlkUo2r7GHLqBy8XivozPm3kVgSWTmIGNKPiWKRv2zdwC24kTntTDy 084AB6l8tdAeQ== Message-ID: Date: Tue, 1 Nov 2022 14:13:38 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.0 Subject: Re: Strange sort node/explain result Content-Language: de-DE To: David Rowley Cc: pgsql-bugs@lists.postgresql.org, corrado@ficicchia.net References: <587a301e-478d-1cbc-288f-6ea77086b097@pro-open.de> From: "Gunnar \"Nick\" Bluth" In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------UENjFQfmektB4kSw9F4QszzW" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------UENjFQfmektB4kSw9F4QszzW Content-Type: multipart/mixed; boundary="------------VCEOyVBKcXdpcEVzPkoae66A"; protected-headers="v1" From: "Gunnar \"Nick\" Bluth" To: David Rowley Cc: pgsql-bugs@lists.postgresql.org, corrado@ficicchia.net Message-ID: Subject: Re: Strange sort node/explain result References: <587a301e-478d-1cbc-288f-6ea77086b097@pro-open.de> In-Reply-To: --------------VCEOyVBKcXdpcEVzPkoae66A Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 QW0gMzEuMTAuMjIgdW0gMjE6NDAgc2NocmllYiBEYXZpZCBSb3dsZXk6DQo+IE9uIFR1ZSwg MSBOb3YgMjAyMiBhdCAwMzoyMCwgR3VubmFyICJOaWNrIiBCbHV0aA0KPiA8Z3VubmFyLmJs dXRoQHByby1vcGVuLmRlPiB3cm90ZToNCj4+IFdoYXQgcHV6emxlcyB1cyBpcyB0aGUgcGFy dCB3aGVyZSB0aGUgQ1RFICJvbmV5ZWFyIiBzb21laG93IGV4cGxvZGVzDQo+PiBpbnRvIGEg c29ydCBub2RlIG9mIGFsbW9zdCAxMCBtaW8gKGJ1dCBub3QgdGhlIHNhbWUgYW1vdW50IGFz IHRoZSBpbmRleA0KPj4gc2NhbiBlbWl0cyEpIHJvd3MsIHRha2luZyB+IDAuNCBzZWNvbmRz IGJ1dCBvbmx5IHVzaW5nIDR4LTV4IGtCIG9mIG1lbW9yeToNCj4+DQo+PiAgICAgLT4gIFNv cnQgIChjb3N0PTY5LjgzLi43Mi4zMyByb3dzPTEwMDAgd2lkdGg9NCkgKGFjdHVhbA0KPj4g dGltZT0wLjQxOC4uNDQ4LjM5NyByb3dzPTk4NTUwMDEgbG9vcHM9MSkNCj4gDQo+IEkgdGhp bmsgeW91J3JlIGludGVycHJldGluZyB0aGUgRVhQTEFJTiBvdXRwdXQgd3JvbmdseS4gIEl0 J3Mgbm90IHRoYXQNCj4gdGhlIFNvcnQgbm9kZSBlbWl0cyA5ODU1MDAxIHJvd3MsIGl0J3Mg dGhhdCA5ODU1MDAxIGFyZSByZWFkIGZyb20gdGhlDQo+IFNvcnQgbm9kZS4NCg0KVGhhbmtz IGZvciBsb29raW5nIGludG8gdGhpcywgRGF2aWQhDQoNCg0KPiBUaGUgcmVhc29uIG1vcmUg cm93cyBhcmUgcmVhZCBmcm9tIGl0IHRoYW4gYXJlIHByb2R1Y2VkIGlzIGJlY2F1c2UNCj4g TWVyZ2UgSm9pbiBtdXN0IHBlcmZvcm0gbWFyayBhbmQgcmVzdG9yZSB0byAicmV3aW5kIiB0 aGUgaW5uZXIgc2lkZSBvZg0KPiB0aGUgc2NhbiBiYWNrIGZvciB0aGUgc3Vic2VxdWVudCBv dXRlciB0dXBsZSB3aGljaCBoYXMgdGhlIHNhbWUgdmFsdWUuDQoNCk9rLCBJIGdldCBpdC4g V2Uga2luZCBvZiBoYWQgdGhhdCBzdXNwaWNpb24uDQoNClNvIHRoZSBzb3J0IGNvdWxkIGFs c28gc2F5DQogICAgInJvd3M9MzY2IGxvb3BzPTI2OTI2Ig0KaW5zdGVhZCBvZg0KICAgICJy b3dzPTk4NTUwMDEgbG9vcHM9MSINCg0KKHdoaWNoIEkgbXlzZWxmIHdvdWxkIGZpbmQgcmVh c29uYWJsZS4uLik/DQoNCjwgc25pcCA+DQoNCj4gVGhlcmUgYXJlIG9ubHkgMzY2IHJvd3Mg Zm9yIHRoZSBTb3J0IG5vZGUgdG8gc29ydC4gNDJrYiBzZWVtcyBsaWtlDQo+IHJlYXNvbmFi bGUgbWVtb3J5IHVzZSBmb3IgdGhhdC4NCg0KQWJzb2x1dGVseSENCg0KVGhhbmtzIGFnYWlu LA0KLS0gDQpHdW5uYXIgIk5pY2siIEJsdXRoDQoNCkVpbWVybWFjaGVyd2VnIDEwNg0KRC00 ODE1OSBNw7xuc3Rlcg0KDQpNb2JpbCArNDkgMTcyIDg4NTMzMzkNCkVtYWlsOiBndW5uYXIu Ymx1dGhAcHJvLW9wZW4uZGUNCl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fDQoiQ2V0ZXJ1bSBjZW5z ZW8gU3lzdGVtRCBlc3NlIGRlbGVuZGFtIiAtIENhdG8NCg0K --------------VCEOyVBKcXdpcEVzPkoae66A-- --------------UENjFQfmektB4kSw9F4QszzW Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wsB5BAABCAAjFiEEalk3A/SRAkpwy/bgEBCuazKJM4wFAmNhG4IFAwAAAAAACgkQEBCuazKJM4yS bQf+MvP3tzvwi00+UMlJ2MRNKAbXBe244xUCLmcowcWbhhIDxJiQoH7L8SoSnMgulB9vUKvfZlja Sr0TqNdqBWdPjv5Vf8FYh3BQN8OSYmoeSO2xG6hqeG53lVTgmUxMdIyLuuY5vxr579ec2hEnaCas A7OMMYaWZVUxv5WoRZmQY9BsEGAQYCOj/r64dscDU45SyWPr6dABC6qp3xEjawNieRRrVfGFGx7e eaE21mcrCaav2PIKjt7AXCV9mXu2reFIeeVAEUimrtYalWQbU0AZwWsxuOezjQbf7agN6AlPnl8m 95mtNteRFZFQ0TtwUXqguXj5KhV7Sl9fo2aP8uW2Tg== =9UKy -----END PGP SIGNATURE----- --------------UENjFQfmektB4kSw9F4QszzW--