Other than creating a functional index on the keys that you most want to
access and include that function call in your query, I don't know that you
can. Functional indexes get statistics while partial indexes do not. If a
GIN index using path operator collected stats on the frequency of the keys,
t
Hi!
I ran into a problem which caused by wrong rows count planner expecting to get
when using ?| operator against jsonb field.
To illustrate the issue:
create table tbl_test (a jsonb);
insert into tbl_test(a)
select jsonb_build_object('val1', 1)
from generate_series(1, 10);
analyse tbl_tes
