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.
- Indexes in JSONB Saurav Sarkar
- Re: Indexes in JSONB Magnus Hagander
- Re: Indexes in JSONB Michael Lewis
- Re: Indexes in JSONB Saurav Sarkar