I have a table of products with custom properties for each product. So I have
props::hstore column in my table. I want the user to be able to search products by key/value by first selecting the key and then entering the value with autocomplete feature. So I need two steps here:
- Get all the keys in
skeysshould work here, but I don't understand how to create index.
- Find most relavent values for fixed key (autocomplete feature). But seems like gin_trgm_ops can create index only on
valuefor fixed keys.
Also, maybe it can be a good idea to change the
jsonb, but I don't see why it can be more perfomant.