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
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
