Is there an index type for BIGINT[]?

Question

I noticed intarray allows an index type for very large INT arrays (gist__intbig_ops), but is there an option for BIGINT[] arrays (gist__bigint_ops)? It will be a small number of BIGINT[] values per record.

Answer 1

Try a GIN index. No extension is needed.

CREATE INDEX index_name ON tablename USING gin(bigint_array_column);