Re: Reproducible coliisions in jsonb_hash - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Reproducible coliisions in jsonb_hash
Date
Msg-id 327353.1652367303@sss.pgh.pa.us
Whole thread Raw
In response to Re: Reproducible coliisions in jsonb_hash  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Reproducible coliisions in jsonb_hash  (Stephen Frost <sfrost@snowman.net>)
List 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 by date:

Previous
From: vignesh C
Date:
Subject: Re: First draft of the PG 15 release notes
Next
From: Andres Freund
Date:
Subject: Re: Mark all GUC variable as PGDLLIMPORT