Using postgresql gin or gist index with bigint column

Question

i am trying to create gin index on bigint column and getting an error (PostgreSQL 9.1.9 / Debian 7).

CREATE TABLE test (id bigint CONSTRAINT test_pkey PRIMARY KEY, field bigint);

CREATE INDEX idx_test_field ON test using GIN(field);

ERROR:  data type bigint has no default operator class for access method "gin"
HINT:  You must specify an operator class for the index or define a default operator class for the data type.

Is there no default support for int8 gin,gist indexes ?

Why do you want to build gin or gist indexes on bigint? Those indexes are for specialized data structures such as geometries, intarray etc.. A simple B-tree index supports >,<,= which is basically all the functionality you need for BIGINTS. — Alexandros
– Alexandros, Commented May 30, 2014 at 7:43

Craig Ringer · Accepted Answer · 2014-05-30 07:52:33Z

28

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;

answered May 30, 2014 at 7:52

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using postgresql gin or gist index with bigint column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related