Feedback-ID: i131946ab:Fastmail
Message-ID: <b37c2acd-24f4-07c9-da6e-6fec66137f69@enterprisedb.com>
Date: Tue, 14 Jun 2022 20:10:44 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0)
 Gecko/20100101 Thunderbird/91.9.1
Subject: Re: Collation version tracking for macOS
Content-Language: en-US
To: Peter Geoghegan <pg@bowt.ie>, Thomas Munro <thomas.munro@gmail.com>
Cc: "Finnerty, Jim" <jfinnert@amazon.com>, "Nasby, Jim" <nasbyj@amazon.com>,
 Tom Lane <tgl@sss.pgh.pa.us>, Jeremy Schneider <schneider@ardentperf.com>,
 pgsql-hackers <pgsql-hackers@postgresql.org>
References: <381977b1-0898-cb6f-a427-3b5d873e81bd@enterprisedb.com>
 <CA+hUKG+PNqUn5oG6hFgPcy7AyxuSbpNKo-u=Bobe=dn7k8sVZw@mail.gmail.com>
 <CAH2-Wzn1jLoe17eEPgHS=q_cnDJ35NNk3kiMgAbQ+i_vd1Uv6w@mail.gmail.com>
 <CA+hUKGJbRBbDHsp6erRpckDa41mH+0UHsTqd1MZSpZVi-mj55A@mail.gmail.com>
 <FBF2C579-4025-47E7-9884-3C6D8C955686@amazon.com>
 <CAH2-Wzmo74tMCLTHJm-WfbbjThoY9+fyzj+SHHY_W5edgmv+8g@mail.gmail.com>
 <CA+hUKGJ7dfvu4i_UMOKK9ufG_BcXaYbKNJaPYKA7BH4NyRPTTQ@mail.gmail.com>
 <CAH2-Wz=G3Y67WDGE_Vv1_wxnZoYxa+ie8YYgjGi98DzFa1tHGg@mail.gmail.com>
 <CA+hUKG+vGwo4uhrOzqR-nsATn-1kH+XUNprGga3MX_KnEw0DNw@mail.gmail.com>
 <CAH2-WzkWM2Ui2QKMmOgvi7Lb8XZo-Bdoy1ae9gm7Dz1ynJp88Q@mail.gmail.com>
 <CA+hUKGKGdQeA6dw7RNzkOSQV5Dj=d+XKxaDSWfh47zK2SRP_6Q@mail.gmail.com>
 <CAH2-WzmGh-8ppxH4_ut7N1+j=7ZQX2-9y+5Qu049upqnRsS1ig@mail.gmail.com>
 <CA+hUKGJRaPdb+AKNzKqdgxnaRpW_iVwj529Wrm9h8y__Qj9s+w@mail.gmail.com>
 <CAH2-WznSi6muvAZsocdGCGnACL+NMziyXEkjDfz0n30BYUwS9w@mail.gmail.com>
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
In-Reply-To: 
 <CAH2-WznSi6muvAZsocdGCGnACL+NMziyXEkjDfz0n30BYUwS9w@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/b37c2acd-24f4-07c9-da6e-6fec66137f69%40enterprisedb.com>
Precedence: bulk

On 11.06.22 05:35, Peter Geoghegan wrote:
> Do we even need to store a version for indexes most of the time if
> we're versioning ICU itself, as part of the "time travelling
> collations" design? For that matter, do we even need to version
> collations directly anymore?

Conversely, why are we looking at the ICU version instead of the 
collation version.  If we have recorded the collation as being version 
1234, we need to look through the available ICU versions (assuming we 
can load multiple ones somehow) and pick the one that provides 1234.  It 
doesn't matter whether it's the same ICU version that the collation was 
originally created with, as long as the collation version stays the same.