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 1r4knd-009yk1-9N for pgsql-bugs@arkaria.postgresql.org; Sun, 19 Nov 2023 16:37:33 +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 1r4knb-004DAU-Hd for pgsql-bugs@arkaria.postgresql.org; Sun, 19 Nov 2023 16:37:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r4joG-0048Vh-A0 for pgsql-bugs@lists.postgresql.org; Sun, 19 Nov 2023 15:34:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r4joD-007Gd2-O6 for pgsql-bugs@lists.postgresql.org; Sun, 19 Nov 2023 15:34:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=i1GeEuVq5wihTMB/wbBZLG5zFCgjzIZHGsZbf50bxis=; b=L5bAaX2jHy6dpVEOtmXQX8dsp8 ZvRaz7M0csk6fNa0S9zG3tZxX8XcKXBw4Phv6rl8L6a8swdbgVQkT0OZz7BGmX7huhmYCdsuTAYJe W99vPzwlGdCSQJQ3ptpPvHY932LU7E/tmnrN79/JJBEyoMHwIzmc7p4nkYUXD8OTPNr/f/wXyUqh2 xFRXicWE0HaefDLtQcEdXibyWCFZ+mGgcR4n4/Sf50UyPTYS8niXixwTIrURLfxEENB+UwnBKHAmd gTlN+7pM8vz/v7TftrupCcN1Qtr+Bpky7zf/o7r2B+Iw9JXRBKD93pzmyOgOcnH1M2Wv9sb8Nr7c7 +GQ2gbHg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r4joB-005gdP-Vj for pgsql-bugs@lists.postgresql.org; Sun, 19 Nov 2023 15:34:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r4jo9-006sZT-E3 for pgsql-bugs@lists.postgresql.org; Sun, 19 Nov 2023 15:34:02 +0000 Content-Type: multipart/mixed; boundary="===============3446321099175553299==" MIME-Version: 1.0 Subject: BUG #18206: Strange performance behaviour depending on location of field in query. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: dmigowski@ikoffice.de Reply-To: dmigowski@ikoffice.de, pgsql-bugs@lists.postgresql.org Date: Sun, 19 Nov 2023 15:33:16 +0000 Message-ID: <18206-5a796f4945e5b39f@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3446321099175553299== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODIwNgpMb2dnZWQgYnk6ICAgICAgICAgIERhbmllbCBNaWdvd3NraQpF bWFpbCBhZGRyZXNzOiAgICAgIGRtaWdvd3NraUBpa29mZmljZS5kZQpQb3N0Z3JlU1FMIHZlcnNp b246IDE1LjUKT3BlcmF0aW5nIHN5c3RlbTogICBXaW5kb3dzICsgTGludXgKRGVzY3JpcHRpb246 ICAgICAgICAKCkkgaGF2ZSBhIHRhYmxlIHdpdGggc29tZSBjb2x1bW5zIGlkIGFuZCBhIHRvIHog YW5kIHRoZXNlIHR3byBxdWVyaWVzIGhhdmUKZHJhc3RpY2FsbHkgZGlmZmVyZW50IHJ1bnRpbWVz Lg0KDQogIHNlbGVjdCBjb3VudChpZCkgRlJPTSB0ZXN0dGFibGUgdCBXSEVSRSB0LnogSVMgTlVM TDsgICgzNSUgc2xvd2VyIHRoYW4KV0hFUkUgdC5hIElTIE5VTEwpDQogIHNlbGVjdCBjb3VudChp ZCkgRlJPTSB0ZXN0dGFibGUgdCBXSEVSRSB0LmEgSVMgTlVMTDsNCg0KVGhpcyBqdXN0IHNjcmVl bXMgbGlrZSBzb21ld2hlcmUgUG9zdGdyZVNRTCBpcyBpdGVyYXRpbmcgb3ZlciBmaWVsZHMgb3Zl cgphbmQgb3ZlciBhZ2FpbiB3aXRob3V0IGFzc2lnbmluZyBmaWVsZCBpbmRleGVzIHRvIHRoZSBs aXRlcmFscy4gDQoNClBsZWFzZSBjcmVhdGUgYSB0ZXN0IHRhYmxlIHRoaXMgd2F5Og0KDQpkcm9w IHRhYmxlIGlmIGV4aXN0cyB0ZXN0dGFibGUgY2FzY2FkZTsNClNFTEVDVCBnZW5lcmF0ZV9zZXJp ZXM6OmludDQgYXMgaWQsIG51bGw6OmludDQgYSwgbnVsbDo6aW50NCBiLA0KICAgIG51bGw6Omlu dDQgYywgbnVsbDo6aW50NCBkLCBudWxsOjppbnQ0IGUsIG51bGw6OmludDQgZiwgbnVsbDo6aW50 NCBnLApudWxsOjppbnQ0IGgsIG51bGw6OmludDQgaSwgbnVsbDo6aW50NCBqLA0KICAgIG51bGw6 OmludDQgaywgbnVsbDo6aW50NCBsLCBudWxsOjppbnQ0IG0sIG51bGw6OmludDQgbiwgbnVsbDo6 aW50NCBvLApudWxsOjppbnQ0IHAsIG51bGw6OmludDQgcSwgbnVsbDo6aW50NCByLCANCiAgICBu dWxsOjppbnQ0IHMsIG51bGw6OmludDQgdCwgbnVsbDo6aW50NCB1LCBudWxsOjppbnQ0IHYsIG51 bGw6OmludDQgdywKbnVsbDo6aW50NCB4LCBudWxsOjppbnQ0IHksIG51bGw6OmludDQgeg0KICAg IGludG8gdGVzdHRhYmxlIA0KICAgRlJPTSBnZW5lcmF0ZV9zZXJpZXMoMSw2MDAwMDAwLDEpOw0K DQpEb2Vzbid0IG1hdHRlcnMgaWYgcGFyYWxsZWwgcXVlcnkgaXMgdXNlZCwgY2FuIGFsc28gYmUg ZGVhY3RpdmF0ZWQuIEJ1dCBpdCdzCnN0cmFuZ2UgdG8gc2VlIHRoYXQgcmVvcmRlcmluZyB0aGUg cGh5c2ljYWwgY29sdW1uIGxheW91dCBjYW4gaGF2ZSBzdWNoIGEKbGFyZ2UgZWZmZWN0IG9uIHRo ZSB0YWJsZXMuCgo= --===============3446321099175553299==--