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 1ty9rd-003B1I-D9 for pgsql-general@arkaria.postgresql.org; Fri, 28 Mar 2025 13:35:13 +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 1ty9rc-00ALT5-1k for pgsql-general@arkaria.postgresql.org; Fri, 28 Mar 2025 13:35:12 +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 1ty9rb-00ALSx-MN for pgsql-general@lists.postgresql.org; Fri, 28 Mar 2025 13:35:11 +0000 Received: from mail-ed1-x533.google.com ([2a00:1450:4864:20::533]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ty9rZ-001iP8-0k for pgsql-general@postgresql.org; Fri, 28 Mar 2025 13:35:11 +0000 Received: by mail-ed1-x533.google.com with SMTP id 4fb4d7f45d1cf-5eb5ecf3217so3968701a12.3 for ; Fri, 28 Mar 2025 06:35:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1743168908; x=1743773708; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=I4gfjBkdZIfuKAx+P/f8dRWlAeiSAgbBGKKftQHvvHk=; b=sSR85RYMVuhsm2Jr9reDrinVtUR4NL5XxTIdrgyh4ubKAAkrsi15m5k9oazZzvO460 1zj/FGArR+2wcDhR10brCzS6CzV+Po6S7lGJw57KFfznJGiZ1CASfh7VQPz+o7M10mC1 Gr6TLBBnzLLJ/uh7cppAhG0VtKlNu38QydHKAf74kpnmyeJwAsC5ZV/mSjFiOTs0tGZn V4+hcxpcfSq6OQH66EuRO3palSn6tTmrHTrWL+F4W5aFrBrdi52YIVy49vxTLpXusy1H i1lZ9PCZuXxJ4FLPUw69vaxRJ09jBJ/Nm5YeIu5EIvcFMsHgnis6FegqeeRsfBBUTR7t jAQw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1743168908; x=1743773708; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=I4gfjBkdZIfuKAx+P/f8dRWlAeiSAgbBGKKftQHvvHk=; b=lW1PwsSsnJHcueDrmekonYMSidtrEgeUP430C/1r5aG7ZrGj3YtgkS/ys95MQ4A41o 8Ik3DEOYiWE73L8cyGdK4s3/Ps4UlboT00NrcrQoQUTT3WEE1a5Eplg4+VmaJtlQ/UUu 0iT/l4CcR0UnHofnehlEMTj0DOIqEz4waQTKkEhTZ2yDqcNaoDzYxcm9CZrtMojU9hDZ +6OyL/BWomlZYt92lAccFmRWIHxQWXW8a7UFX0g+wnwjs6BBgjIdJa+PVJBilyQ56pjp XUWnKPg4KqFdpNJ0HcrXuDM14UYpYeWdjtkCvPQtvqX4xhD2OsUv+ebfUTCUr/YtIwGv FmWg== X-Forwarded-Encrypted: i=1; AJvYcCW0MBYVgtZV3Bpw2LVCf7RMKVS25tGpliIj3QvOi5ytG5s18DJIUQxN8cSz/Dj9fw9fz5n4eeFZ27aIH3Ls@postgresql.org X-Gm-Message-State: AOJu0YwB2+rhJgMQVQXwFSQpFaH43zvbsOPWJqLX346aeHMKUsjjeJhS 2YTK5CNxm0V6rQIwQQcQTGQrc1iAhgT1PrtahgvjlmNmdRQNAkZh69YB/AVV6Gs= X-Gm-Gg: ASbGncu5F5NLmFxX1BpjKHj2I1YZDoGNUKJbXZrpQOcRSWsncC1LtBK5+/F09EKIAZW b2o0QpGudZULLonLxfAnv0jXBN0hDV9VqwvyjR4V9NYaG7LhhG09NqBKPNVUP5UoqyLcGRIgMxl FM4iRkD+BUFYXQahMuDkm5gHieVJZ39nd9eMSf3pieQRpqtJXGx9aNfZ9BdLMw4j8GPXXClhCMG EIKxEUaFA4NHDwr0OtKiyfnwtFut7p66YYt2nxgqtYrEdZibIwHsybfVRScp8I5cDu0pIwTSpLh o+n6eZ1Hn0gbat7oNezB6JakM8Eir7o+0s9fzRI/iZNlbkKrPdhPnllzDrAbvZBZ8w== X-Google-Smtp-Source: AGHT+IEhKh8AyylHI3xkvax/AjP0QVWh9m8QjTSUrUOUWHTEFd89+rdcnb/FG3XdIras8hwkWI9DSw== X-Received: by 2002:a17:907:78b:b0:abf:67de:2f1f with SMTP id a640c23a62f3a-ac6fb0ff500mr777184166b.44.1743168907796; Fri, 28 Mar 2025 06:35:07 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:9fb3:4931:4b78:b33c:36b9]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-ac719223e4dsm162902466b.24.2025.03.28.06.35.06 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 28 Mar 2025 06:35:07 -0700 (PDT) Message-ID: Subject: Re: BTREE index: field ordering From: Laurenz Albe To: Moreno Andreo , PostgreSQL mailing lists Date: Fri, 28 Mar 2025 14:35:05 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gRnJpLCAyMDI1LTAzLTI4IGF0IDEzOjM4ICswMTAwLCBNb3Jlbm8gQW5kcmVvIHdyb3RlOgo+ IMKgUG9zdGdyZXMgMTYuNCAocGxhbm5pbmcgdG8gZ28gb24gMTcuNCkgCj4gwqBJJ20gY3JlYXRp bmcgc29tZSBpbmRleGVzIGJhc2VkIG9uIHNvbWUgc2xvdyBxdWVyeSByZXBvcnRlZCBieSBsb2dz LiAKPiDCoFRoZXNlIHF1ZXJpZXMgaW52b2x2ZSBhIFdIRVJFIHdpdGggbW9yZSB0aGFuIDUgZmll bGRzLCB0aGF0IGFyZSBtYXRjaGluZyBieSA9LCA8PiwgTElLRSBhbmQgSU4oKSAKPiDCoEkgcmVh ZCB0aGF0IGVxdWFsaXR5IGZpZWxkcyBtdXN0IGJlIGZpcnN0LCB0aGVuIHRoZSBvdGhlcnMuIAo+ IMKgSXMgaXQgY29ycmVjdD8KCkZ1bmRhbWVudGFsbHkgeWVzLCBidXQgeW91IGFsc28gaGF2ZSB0 byBjb25zaWRlciBob3cgc2VsZWN0aXZlIHRoZSBjb25kaXRpb25zIGFyZS4KUHV0dGluZyBhIGNv bHVtbiBpbiB0aGUgaW5kZXggd2hlcmUgdGhlIGNvbmRpdGlvbiB3aWxsIG9ubHkgZmlsdGVyIG91 dCBmZXcgcm93cwppcyBub3QgZ29pbmcgdG8gaGVscDsgc3VjaCByb3dzIHNob3VsZCBiZSBvbWl0 dGVkIGZyb20gdGhlIGluZGV4LgoKPiBCYXNlZCBvbiB0aGlzIHF1ZXJ5IAo+ICAgICAgICAgICAg ICAgIMKgwqBTRUxFQ1QgQ09VTlQoaWQpIEFTIHRvdGFswqAKPiDCoMKgwqDCoMKgwqDCoMKgwqDC oMKgwqDCoMKgwqDCoCBGUk9NIG54LnRibDEgCj4gwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDC oMKgwqAgV0hFUkUgCj4gwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIChkYXRlX29yZGVyID49ICcy MDI1LTAzLTIxJykgCj4gwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIEFORCAoZGF0ZV9vcmRlciA8 PSAnMjAyNS0wMy0yOScpIAo+IMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoCBBTkQgKGZsYWcgPSBU UlVFKSAKPiDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgQU5EICgoIAo+IMKgwqDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgwqAgLS0gKGZsYWcgPSBUUlVFKSAKPiDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg wqDCoMKgIC0tIEFORCAoKCh0aXBvIDw+ICdDJykgQU5EICh0aXBvIDw+ICdWJykgQU5EICh0aXBv IDw+ICdGJykpIE9SICh0aXBvIElTIE5VTEwpIE9SICh0aXBvID0gJycpKSAKPiDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgwqDCoMKgICgoKG9wIDw+ICdDJykgT1IgKG9wIElTIE5VTEwpKSBPUiAodGlw byA9ICdGJykpIAo+IMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgQU5EIChzX3N0YXRlIElO ICgnRU5RJywnV0ZSJywnQkxRJywnQkxSJywnV0ZBJywnRlJXJywnRlJPJywnMDAwMCcsJzAwMDEn KSkgCj4gwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoCBBTkQgKHRpcG9yaWMgSVMgTk9UIE5V TEwpIAo+IMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgQU5EICh0aXBvcmljIE5PVCBMSUtF ICclY2FydCUnKSAKPiDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgKSBPUiAoIAo+IMKgwqDCoMKg wqDCoMKgwqDCoMKgwqDCoMKgwqAgKHRpcG9yaWMgTElLRSAnJWNhcnQlJykgQU5EIChTX3N0YXRl IDw+ICdDT04nKSBBTkQgKHNfc3RhdGUgPD4gJzAwMDInKSBBTkQgKChvcCA8PiAnQycpIE9SIChv cCBJUyBOVUxMKSkgCj4gwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgICkpwqAgQU5EIChwcml2IElT IE5VTEwgT1IgcHJpdiA9IGZhbHNlIE9SIChwcml2ID0gdHJ1ZSBhbmQgaWRwcml2ID0gJ1RFU1Qn KSkpOyAKPgo+IMKgU2hvdWxkIHRoZSBmb2xsb3dpbmcgaW5kZXggYmUgY29ycmVjdD8gCj4gCj4g wqBDUkVBVEUgSU5ERVggSUYgTk9UIEVYSVNUUyB0YmwxX2NvdW50X2lkeCBvbiBueC50YmwxIFVT SU5HIEJUUkVFKGZsYWcsIHRpcG8sIG9wLCBwcml2LCBpZHByaXYsIGRhdGVfb3JkZXIsIHNfc3Rh dGUsIHRpcG9yaWMpOyAKPiDCoAo+IMKgV291bGQgaXQgYmUgYmV0dGVyIHRvIGNyZWF0ZSBhIHNl cGFyYXRlIEdJTi9HSVNUIGluZGV4IGZvciB0aGUgZmllbGQgbWF0Y2hlZCB3aXRoIExJS0U/IAoK VGhlIE9ScyB3aWxsIGJlIGEgcHJvYmxlbS4gR2V0IHJpZCBvZiB0aGVtIGFzIG11Y2ggYXMgcG9z c2libGUgYnkgdXNpbmcgVU5JT04sCmF0IGxlYXN0IGZvciBXSEVSRSBjb25kaXRpb25zIHRoYXQg YXJlIHNlbGVjdGl2ZS4KCllvdXJzLApMYXVyZW56IEFsYmUK