On Mon, Sep 15, 2014 at 2:12 PM, Josh Berkus <josh@agliodbs.com> wrote:
> If not, I think the corner case is so obscure as to be not worth
> optimizing for. I can't imagine that more than a tiny minority of our
> users are going to have thousands of keys per datum.
Worst case is linear cost scaling vs number of keys, which depends on
the number of keys how expensive it is.
It would have an effect only on uncompressed jsonb, since compressed
jsonb already pays a linear cost for decompression.
I'd suggest testing performance of large small keys in uncompressed
form. It's bound to have a noticeable regression there.
Now, large small keys could be 200 or 2000, or even 20k. I'd guess
several should be tested to find the shape of the curve.