Re: Reproducible coliisions in jsonb_hash

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Reproducible coliisions in jsonb_hash
Дата
Msg-id 327353.1652367303@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Reproducible coliisions in jsonb_hash  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Reproducible coliisions in jsonb_hash  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> Here, that doesn't seem too likely. You could have a column that
> contains 'tom' and ['tom'] and [['tom']] and [[['tom']]] and so forth
> and they all get mapped onto the same bucket and you're sad. But
> probably not.

Yeah, that might be a more useful way to think about it: is this likely
to cause performance-critical collisions in practice?  I agree that
that doesn't seem like a very likely situation, even given that you
might be using json for erratically-structured data.

            regards, tom lane



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

Предыдущее
От: vignesh C
Дата:
Сообщение: Re: First draft of the PG 15 release notes
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Mark all GUC variable as PGDLLIMPORT