Postgres Pro
Downloads
Home   >   mailing lists

Re: Indexing on JSONB field not working - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: Indexing on JSONB field not working
Date
Msg-id CAMkU=1y+D8SyZ+MOQAsJN_4HRm5QaLWFgKe2MyXbkbz0d5fmrA@mail.gmail.com
Whole thread Raw
In response to Re: Indexing on JSONB field not working  (Zhihong Zhang <zhihong@gmail.com>)
Responses Re: Indexing on JSONB field not working  (Zhihong Zhang <zhihong@gmail.com>)
List pgsql-bugs
Tree view
On Fri, Dec 27, 2019 at 3:26 PM Zhihong Zhang <zhihong@gmail.com> wrote:
Finally got stats on the new table assets_copy. Still don’t know what’s the magic. I have 2 indexes in this new table, only this one got stats.

Only one of your indexes is over an expression.  The index over a plain column will never have stats, as column stats are stored with the table, not the index.

Cheers,

Jeff

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: A row-level trigger on a partitioned table is not created on asub-partition created later
Next
From: Jeff Janes
Date:
Subject: Re: Indexing on JSONB field not working