Re: proposal: change behavior on collation version mismatch

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: proposal: change behavior on collation version mismatch
Дата
Msg-id 27955d85f65ee64e83b2ade8c50e55d3f53695c0.camel@j-davis.com
обсуждение исходный текст
Ответ на Re: proposal: change behavior on collation version mismatch  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-hackers
On Mon, 2023-11-27 at 22:37 +0100, Magnus Hagander wrote:
> That is, set it to "warnings only", insert a single row into the
> table
> with an "unlucky" key, set it back to "errors always" and you now
> have
> a corrupt database, but your setting reflects that it shouldn't be
> corrupt.

You would be giving the setting too much credit if you assume that
consistently keeping it on "error" is a guarantee against corruption.

It only affects what we do when we detect potential corruption, but our
detection is subject to both false positives and false negatives.

We'd need to document the setting so that users understand the
consequences and limitations.

I won't push strongly for such a setting to exist because I know that
it's far from a complete solution. But I believe it would be sensible
considering that this problem is going to take a while to resolve.

Regards,
    Jeff Davis




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Don't use bms_membership in places where it's not needed
Следующее
От: Nathan Bossart
Дата:
Сообщение: Re: autovectorize page checksum code included elsewhere