Support for json/jsonb data types about index_advisor HOT 2 OPEN

That's right, we currently only support single column btree indexs, which are not appropraite for json/b data types.

The underlying HypoPG extension has support for

btree
brin
hash (requires PostgreSQL 10 or above)
bloom (requires the bloom extension to be installed)

so, unfortunately, there is currently no appropriate target for JSON/B columns

I'll leave this open in case other come across this limitation too

from index_advisor.

Nevermind, looks like it's intended behavior:

and pa.atttypid in (20,16,1082,1184,1114,701,23,21,700,1083,2950,1700,25,18,1042,1043)

the atttypid for jsonb is 3802.

If I remove the restriction it attempts to create an index but not a correct one for the query:

 public      | products   | properties  | select public.hypopg_create_index($i$create index on public.products(properties)$i$)

Which, I assume, is why there was a limited list of supported attypid in the first place.

from index_advisor.