On Fri, Dec 20, 2019 at 5:12 PM Zhihong Zhang <zhihong(at)gmail(dot)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