The btree_gin module provides sample generalized inverted index (GIN) operator classes that implement B-tree equivalent behavior for certain data types.
The Greenplum Database btree_gin module is equivalent to the PostgreSQL btree_gin module. There are no Greenplum Database or MPP-specific considerations for the module.
Installing and Registering the Module
The btree_gin module is installed when you install Greenplum Database. Before you can use any of the functions defined in the module, you must register the btree_gin extension in each database in which you want to use the functions:
CREATE EXTENSION btree_gin;
Refer to Installing Additional Supplied Modules for more information.
Greenplum Database Limitations
The VMware Greenplum Query Optimizer (GPORCA) does not support queries that access an index with op_class, such queries will fall back to the Postgres Planner
Module Documentation
See btree_gin in the PostgreSQL documentation for detailed information about the individual functions in this module.
