Re: Indexes in JSONB - Mailing list pgsql-general

From Michael Lewis
Subject Re: Indexes in JSONB
Date
Msg-id CAHOFxGp-cqBZE98znhPfZiGkPwmms9Yp=jQs=jyQF9bhheP9CQ@mail.gmail.com
Whole thread Raw
In response to Re: Indexes in JSONB  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general
No matter what you do, you will not typically get the same level of performance as normalized tables as you do not get statistics on the values stored in your jsonb column. No knowledge of null fraction, number of distinct values, or most common values and their frequencies.

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Indexes in JSONB
Next
From: Saurav Sarkar
Date:
Subject: Re: Indexes in JSONB