Re: Collation version tracking for macOS - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Collation version tracking for macOS
Date
Msg-id 1618486.1654697761@sss.pgh.pa.us
Whole thread Raw
In response to Re: Collation version tracking for macOS  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Collation version tracking for macOS
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Tue, Jun 7, 2022 at 3:53 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> No, I quite agree that we have a problem.  What I don't agree is that
>> issuing a lot of false-positive warnings is a solution.

> I mean, how many false-positive warnings do you think we'll get?

The proposed patch would result in a warning about every collation-
sensitive index during every macOS major version upgrade, ie about
once a year for most people.  Seeing that Apple only actually touch
their POSIX collations once a decade or so, that's way too far over
on the crying-wolf end of the scale for me.  We need something that
has at least *some* connection to actual changes.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Jakub Wartak
Date:
Subject: RE: pgcon unconference / impact of block size on performance
Next
From: Stephen Frost
Date:
Subject: Re: replacing role-level NOINHERIT with a grant-level option