balasubramanian c r writes:
> when Operator '@>' is used the index is used and the execution time is 60ms.
Yeah ... note that it's predicted to return just one row, and that
guess is correct:
> Bitmap Heap Scan on public.address18 (cost=261.25..262.52 rows=1 width=4)
> (actual time=58.992..58.
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.
