GIN INdex is not used with && operator for a text array index

HI Team Sorry for the spam. We have Postgres DB where the list of addresses are stored and for a given complete address trigram of addresses are stored in a column which is a text array. after looking at the list of operators that are available for gin index I decided to use array_ops operator.

Re: Querying a table with jaccard similarity with 1.6 million records take 12 seconds

HI Tom/Ninad My bad I didn't explain my use case properly. The use case is to find the best string similarity for a given address against the list of addresses in the table. Initially I tried a similarity function provided by the pg_trgm extension. But the similarity scores were not satisfactory. L

Re: Querying a table with jaccard similarity with 1.6 million records take 12 seconds

rds, > Ninad Shah > > > On Thu, 2 Sept 2021 at 16:39, balasubramanian c r > wrote: > >> Hi Team >> >> We have encountered a problem in our testing environment. >> I have a scenario where I am running a similarity match for an address >> I ha

Querying a table with jaccard similarity with 1.6 million records take 12 seconds

Hi Team We have encountered a problem in our testing environment. I have a scenario where I am running a similarity match for an address I have created a table with following number of records 1603423 We are using pg_similarity extension in postgresql version is 13. And I have created GIN index