Re: Collation version tracking for macOS

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: Jeremy Schneider <schneider(at)ardentperf(dot)com>
Cc: Jeff Davis <pgsql(at)j-davis(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>, Peter Geoghegan <pg(at)bowt(dot)ie>, "Nasby, Jim" <nasbyj(at)amazon(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Collation version tracking for macOS
Date: 2022-11-29 18:18:17
Message-ID: CA+hUKG+g-AFta22P0NjuFTbi3jywWTqR+dyExQwu5Vr=mSeXUw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Nov 30, 2022 at 7:03 AM Jeremy Schneider
<schneider(at)ardentperf(dot)com> wrote:
> It seems to me that the collator_version field is not a good version
> identifier to use.
>
> Just taking a quick glance at the ICU home page right now, it shows that
> all of the last 5 versions of ICU have included "additions and
> corrections" to locale data itself, including 68 to 69 where the
> collator version did not change.
>
> Is it possible that this "collator_version" only reflects the code that
> processes collation data to do comparisons/sorts, but it does not
> reflect updates to the locale data itself?

I think it also includes the CLDR version for *some* locales. From a
quick look, that includes 'ar', 'ru', 'tr', 'zh'. Jeff, would you
mind sharing the same table for one of those? Perhaps 'en' really
does depend only on the UCA?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dimos Stamatakis 2022-11-29 18:21:54 Re: Fix for visibility check on 14.5 fails on tpcc with high concurrency
Previous Message Alvaro Herrera 2022-11-29 18:04:44 Re: ExecRTCheckPerms() and many prunable partitions