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.96) (envelope-from ) id 1wOv8O-000HgW-1w for pgsql-hackers@arkaria.postgresql.org; Mon, 18 May 2026 10:23:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wOv8M-001eL5-1X for pgsql-hackers@arkaria.postgresql.org; Mon, 18 May 2026 10:23:39 +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.96) (envelope-from ) id 1wOv8M-001eKx-0O for pgsql-hackers@lists.postgresql.org; Mon, 18 May 2026 10:23:39 +0000 Received: from mail-lf1-x12b.google.com ([2a00:1450:4864:20::12b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wOv8I-00000000AYP-15ZI for pgsql-hackers@postgresql.org; Mon, 18 May 2026 10:23:38 +0000 Received: by mail-lf1-x12b.google.com with SMTP id 2adb3069b0e04-5a8fbe18b1dso3357402e87.2 for ; Mon, 18 May 2026 03:23:33 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1779099812; cv=none; d=google.com; s=arc-20240605; b=kMUmOQjb3vKriWng/HQpS4ra/sQSMXqnnFTrErWHrPRka8T0SaUHnRHCr7Xtii1BVg kCECNXBPzKXbiJKiCMvelhrk2WEy34Bc7yDZNlh30RJfPsX2RE7y1jKe3s2HL6m80o/G h6m2PBGqaVA7Qw0KkJ0Pf2yVLNDGrmgTMNlCsueB9iCb0QScSnuaUnY01sHhYwd14eQ6 rCd/ju0nN0O8H6ywogBMBF44jISIMov6EnJT+qalPjdLAPEzzAvzaDsXN4oOg+/5LWCU b9L6FOMMFCb+kWl9grOea8BpWZM+S4meu6AcdEbzkmA97Uh0/vp593qYbPLnFZs5udwP PsSQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=ujq7OJORqy5VbCZLr4ijYdpGqeqoB0sWCS3wK5ortmY=; fh=plZD5OXAVo90lISdKY3la6o1ykt6xftKjh0Z65QB1IE=; b=NXiCIqBimZSMMubg1KrgLh0S7xymjewNmKORnrfvqBYG7unkBpd4BrEJzEubX9ou1O p8rD1oMzzC1OlmRCeUvkTwOZnDEwZ6G0/FYIZa2zY7CFpLsz1Y4+MieERcfmncg8NyKm t34RFmw5FCTxRM4l3hZRf8SL8f7swxzHu3ZmMbuITJSTdlwPTinpXYDlH0bK0Z2XdxIw vRYqVnvwhzSDw9+vuSDuPWesxMU0YOuHaZipw4nvQfz/kfsyEd/HQ5nf4GOpAaXg7S8H zhWzIncMOrszp6IpEJdUtW78LlHgZfvSa0P4ywHcO+djrQBGBzVC/YaRPL92M9n0HZ2I fpjQ==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=jeltef.nl; s=google; t=1779099812; x=1779704612; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=ujq7OJORqy5VbCZLr4ijYdpGqeqoB0sWCS3wK5ortmY=; b=dCUXKuU4Q/K1GEQjMQzCVo7SoNwhIlVhoN9OVXrqc8NwlQzV0g/2cvS6iiRcTCTPOw dAe3ltmCXtnMgr8PKoDdbIKluAX7dXrlcZ8D4dv3VmmlVq8TgF+BtT/ejTQQf31Jy4pM moyJAZeqRCo+7heyTIEh/QVlIteeInOZqDej67kJdn4AkIGHbkkeQpPSHFQWJynfZCtc 5pc3JGBCBMPwasjzNq61nKSbLkkcwLl+I5i8jS2wJEfpP4s74LS4Kyox0VssqRO9cfxO 7rBreriEdacDuQ8ZaWbPfdDaYb/DwhakTHq/u/XKwxGm0VA153rM9ftD2BOgagHIiPVD CFbg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779099812; x=1779704612; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=ujq7OJORqy5VbCZLr4ijYdpGqeqoB0sWCS3wK5ortmY=; b=LLGptG0Fd3eO3jIboDDYKlSx8YMCXmu7+5RIFWkSe9GDMeDf0bPYvPiFD38yAu8vp4 CTza5/fMmPt8mI+2y1L9vd7ynakV+tvzVd7PJB1WnS3Q0Mze42B9gYX8e94zSIaBjfoi Uj6IrMjdipAT5SXY5k/l9BSv0HOPWxiwmqOj0knu2d6pRpcm4ZEIKuKgBrdCrF5B3uIO YnJcUe2YGUgU5q0M0axr5MCJI35Y9mId8+gvCTrqG6gE7gDMc3ntuVqMmeqeODIWJswb yF3wY5uBgFzK9C0dgc/pmbLUQ+76xBJGaYl2TnFwCpZQVaVTH+GXAyTbqV4RaZVxQaSl 3mQg== X-Forwarded-Encrypted: i=1; AFNElJ8ejY4rgtC/3LU61oz9QEvAmHlApp7ZJk0dTWd16BNGP/8CrIpA949N8aV7zTYySuSDMczu30ByS9NgWyyP@postgresql.org X-Gm-Message-State: AOJu0Yw0OIVlPLio101MX12S03Mxg2npfAGY02CsmskMPkJNG2aaEMEx 7Nsc+Z3OnPOcuhzbsM2J/mRs4mMxIs6O/t54ClkFhAA8zrIwN65G0wRNY/R+Emnv55plAnupnyO r6dbq3cuvYcRWH3qhq+WKHwsDwVMwq3YLumXwkVelyg== X-Gm-Gg: Acq92OHSMxgfL9TlNglfrQq/Qv+Zxz3phmI/6Y2XLT9E1qEM4GrdGnsMbYUMtdo8FbK CoZJBKBLoUNE/sjjsTp5nSqte73AMK2ezVvUjEsvlPGTarX+5ZitR6WgOzEf8AePgd6XYPI/d3z lKhHSbNHjgTRUcqrlr8JOzY8aWmhtwrh/WqdMGwvm61x5dLd/locfNlEJwFKfzyh4Fva0rqga4/ 9EcUj95wrKL5Jo+qgtfeFQ6k+33ZDKijM4MeRB7nsk/41LTZIQtm/zE0kUqcbaNSVtXydaty38N ziMtIiHlwOUsTPkImzo= X-Received: by 2002:a05:6512:15aa:b0:5a8:96cf:c8c4 with SMTP id 2adb3069b0e04-5aa0e7435ebmr4736890e87.15.1779099812327; Mon, 18 May 2026 03:23:32 -0700 (PDT) MIME-Version: 1.0 References: <3104729e-1fbf-4368-ac21-1f670062de28@eisentraut.org> <0ca761b5-7b62-42a1-bffd-8bedefad48dd@eisentraut.org> <62156cde-b2c5-4375-b47a-9730aa8f7b5e@eisentraut.org> <07fdbb85-c530-48d0-adc0-7d43d7951e1b@eisentraut.org> In-Reply-To: From: Jelte Fennema-Nio Date: Mon, 18 May 2026 12:23:20 +0200 X-Gm-Features: AVHnY4IhFjfmbxJO6e08Wazexch03222GXWo2GCKXq-bXdrLeZWNqqP1O49Gdko Message-ID: Subject: Re: Support LIKE with nondeterministic collations To: Peter Eisentraut Cc: jian he , Heikki Linnakangas , Jacob Champion , pgsql-hackers , Daniel Verite , Paul A Jungwirth Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 27 Nov 2024 at 09:01, Peter Eisentraut wrote: > I have committed it, thanks. This commit introduced a regression[1], which makes psql \d and our tests much slower than they need to be, because indexes are not used anymore when they should be. Pinging here, since that thread got no response so far. [1]: https://www.postgresql.org/message-id/DHBQIZX8SZVI.ZX614ZMFL645@jeltef.nl