Hi all,
I need help in full text search optimization for hstore type. I added my
query to explain.depesz, you can check the query and also i added explain
analyze result in this link: https://explain.depesz.com/s/QT1e
table_ord.ops column type is hstore. I couldn't find the effective index
that would reduce the run time of the query.
When I tried to add an gin index to the hstore column, I got the following
error:
create index on table_ord USING gin (ops);
ERROR: index row size 2728 exceeds maximum 2712 for index " table_ord_
ops_idx"
How can I fix this query ?
Best Regards,
Burhan Akbulut
DBA - Cooksoft