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=1zPbphLfucRN7j7bAwb=9YAGB0cucc_t_MaqKk+rwYTQw@mail.gmail.com
Whole thread Raw
In response to 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 20, 2019 at 5:12 PM Zhihong Zhang <zhihong@gmail.com> wrote:

I have an index on JSONB fields like this,

 

CREATE INDEX float_number_index_path2

    ON public.assets USING btree

    (((_doc #> '{floatValue}'::text[])::double precision) ASC NULLS LAST)

    TABLESPACE pg_default;

 

However query doesn’t use it,


Did you analyze the table after building the index?  Expression indexes have their own statistics, but they don't get populated until the table is analyzed.

Cheers,

Jeff

pgsql-bugs by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Indexing on JSONB field not working
Next
From: Jeremy Schneider
Date:
Subject: Re: logical decoding bug: segfault in ReorderBufferToastReplace()