Using postgresql gin or gist index with bigint column
There's generally no reason to create a GiST or GIN index on a primitive type.
If you do require this - say, if you want a composite index that includes both some primitive types and some more complex GiST / GIN-only index types - then you will want the btree_gist
or btree_gin
modules, as appropriate.
CREATE EXTENSION btree_gin;