Re: Indexes in JSONB

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Saurav Sarkar <saurav(dot)sarkar1(at)gmail(dot)com>, PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Indexes in JSONB
Date: 2022-03-29 14:32:09
Message-ID: CAHOFxGp-cqBZE98znhPfZiGkPwmms9Yp=jQs=jyQF9bhheP9CQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Saurav Sarkar 2022-03-29 15:12:21 Re: Indexes in JSONB
Previous Message Magnus Hagander 2022-03-29 08:49:46 Re: Indexes in JSONB