[ACCEPTED]-Using postgresql gin or gist index with bigint column-bigint
Accepted answer
There's generally no reason to create a 6 GiST or GIN index on a primitive type.
If 5 you do require this - say, if you want a 4 composite index that includes both some 3 primitive types and some more complex GiST 2 / GIN-only index types - then you will want 1 the btree_gist or btree_gin modules, as appropriate.
CREATE EXTENSION btree_gin;
Source:
stackoverflow.com
More Related questions
Cookie Warning
We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.