- I have a
text[]
column in Postgres 9.5 - I am planning on running a lot of queries with
@>
against it - I have a GIN index on this column
Normally you need to use the correct Postgres operator so that an index is consulted for your query. There is no operator that is the "opposite" of @>
as far as I know.
I ran EXPLAIN ANALYZE
on a query for this table and it takes 8 times as long to run WHERE NOT column @> array['thing']
as it does to run WHERE column @> array['thing']
. The planner reports that it does a filter
for WHERE NOT
instead of a bitmap index scan on my index.
What is the correct way to negate @>
so that my index is consulted?
I'm willing to create new indexes for this column, including functional indexes if that's the answer.