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 1pT7aF-0005cZ-Hh for pgsql-hackers@arkaria.postgresql.org; Fri, 17 Feb 2023 20:43:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pT7aE-00045d-5n for pgsql-hackers@arkaria.postgresql.org; Fri, 17 Feb 2023 20:43:54 +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 1pT7aD-00045U-SQ for pgsql-hackers@lists.postgresql.org; Fri, 17 Feb 2023 20:43:53 +0000 Received: from mail-pl1-x635.google.com ([2607:f8b0:4864:20::635]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pT7aB-0002o9-IO for pgsql-hackers@postgresql.org; Fri, 17 Feb 2023 20:43:53 +0000 Received: by mail-pl1-x635.google.com with SMTP id jk12so2958311plb.5 for ; Fri, 17 Feb 2023 12:43:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20210112.gappssmtp.com; s=20210112; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=+U218VpKDVgj1U3qVt9hCsNH6CkpHbBDCoCJcJGIFwk=; b=dZGPpREVb1Theg9JaRtPIw6sI/Le+iNKgg0myFss3sSqYtpP3vaeyKVOSOWaA2aLUa j+cLkMWFfncNinTrAT4QfVbn4CE3rRVcCm95ANNsfGirMIL7OWPJF9I/CW6MV38qLL2t H5t8jq7wkOFi8ZKvlfMfBsFQUJiLmVeF4XOWl7waOlch2CtNLzS3SQvvc7QoQBEY//pQ zV3H9kcFL0hojUabUG9tUhfdR9v6C3JYaUKbIDmd59CSL8ow59F42q3EBnap6cR3/ZQs mtZ66vLjHzE58jOPXvf5L9EkTsUWM2yE/Vc2NO9hEfvH91360okFfBIc/ZkHRMRTDQhY jyRg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=+U218VpKDVgj1U3qVt9hCsNH6CkpHbBDCoCJcJGIFwk=; b=Gm0xR+MCEtT/+sRu5+SLW1v04VML/s/rAcq7YeC0JUKZj9mdYm2rqQ9PXEgi+K9rei arnYIJ9jrICGdsbGwbDPwUjkfgY0BjLRQRSLjVxxs/08CPNbRw0vpWmcjB6K6qejyNHE 9ndHN+RwZpAWYMOU28xjBVmBF45v78a44JQSjbpuuBqmVY81r0o7nFA0PyE1+BZ+/L18 arQ5RNtm7QMluvHrxt3NV09KK2Gl1HmlW+hdCY8LeyWmcJYVs+guoQFRJdpGz5B+p5k5 ksJg7D4xSYqXhvI43F+Ih7JHKEnpMajkw0P07+GP3Z9JUUPfHaqaXEHGqgssD05Sgf3l 6pAQ== X-Gm-Message-State: AO0yUKXSaTmQZGuZCL6VWI4WNbusgKdu/eN0xQ7YsRu1TaC36qRh7vtm NCnbRm5nBeeoIyiIVXojAbrkCw== X-Google-Smtp-Source: AK7set8R/nv2/ZrpYScqUnR/nA1JIZjCdd2InBCSSLT6pVjPz/bksTDVSHX4nGyQSx+8oIT9PUijTQ== X-Received: by 2002:a17:90b:4b88:b0:233:e2f3:9d3c with SMTP id lr8-20020a17090b4b8800b00233e2f39d3cmr1041315pjb.18.1676666629180; Fri, 17 Feb 2023 12:43:49 -0800 (PST) Received: from jeff-laptop.lan (c-73-231-146-4.hsd1.ca.comcast.net. [73.231.146.4]) by smtp.gmail.com with ESMTPSA id q20-20020a638c54000000b004fbd10af99asm3122519pgn.60.2023.02.17.12.43.48 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 17 Feb 2023 12:43:48 -0800 (PST) Message-ID: Subject: Re: Move defaults toward ICU in 16? From: Jeff Davis To: Pavel Stehule Cc: Andres Freund , Tom Lane , Thomas Munro , Robert Haas , pgsql-hackers@postgresql.org Date: Fri, 17 Feb 2023 12:43:47 -0800 In-Reply-To: References: <510d284759f6e943ce15096167760b2edcb2e700.camel@j-davis.com> <1590310.1675379449@sss.pgh.pa.us> <337d581bae5d6253919f70acdfc184631f0ad41b.camel@j-davis.com> <20230209022234.gihj4apas6ycaddq@awork3.anarazel.de> <5ffeafe843d43a975f31479fbd211ab88404841b.camel@j-davis.com> <20230211020042.uthdgj72kp3xlqam@awork3.anarazel.de> <20230214175957.idkb7shsqzp5nbll@awork3.anarazel.de> <2a7feb71dbdcea31478b3974b8075982ac2326d2.camel@j-davis.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2023-02-17 at 18:27 +0100, Pavel Stehule wrote: > Today I tested icu for Czech sorting. It is a little bit slower, but > not too much, but it produces partially different results. Thank you for trying it. If it's a significant slowdown, can you please send more information? ICU version, libc version, and testcase? > select row_number() over (order by nazev collate "cs-x-icu"), nazev > from obce=20 > except select row_number() over (order by nazev collate "cs_CZ"), > nazev from obce; >=20 > returns a not empty set. So minimally for Czech collate, an index > rebuild is necessary Yes, that's true of any locale change, provider change, or even provider version change. --=20 Jeff Davis PostgreSQL Contributor Team - AWS