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
